tag:blogger.com,1999:blog-29438013.post2698999212989302874..comments2023-07-01T07:07:08.839-04:00Comments on Rafael Salas: Split Content of a Table Evenly on a Given Number of FilesRafa Salashttp://www.blogger.com/profile/16375071697865176825noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-29438013.post-77021466205187975912010-05-03T18:10:06.839-04:002010-05-03T18:10:06.839-04:00Hi Rafael, this logic works perfect.i have added f...Hi Rafael, this logic works perfect.i have added few stps into my pkg, where i am dynamically building the multiple files with date & timestamp as requirement.<br /><br />i am having one issue.how can i add the row counts for each file?<br />when i am trying to use "Rowcount" option with a variable in between OLDB source & Flatfile destination, and then with scripting trying to put in all the files, its though showing "SUCCESSFUL" but not appending in each file , while its creating a separate file to give the counts of all multiple file in one sigle line <br /><br />please advicepriyankohttps://www.blogger.com/profile/11806045999488552387noreply@blogger.comtag:blogger.com,1999:blog-29438013.post-33736861722583876292010-02-26T08:11:34.989-05:002010-02-26T08:11:34.989-05:00Hi Rafael,
The package runs great, I was wonderin...Hi Rafael,<br /><br />The package runs great, I was wondering how does the value of the variable "SourceQuery" change inside the loop. I do not see any script task or something else that could be doing that.<br /><br />Regards,<br /><br />Suresh.Sunnyhttps://www.blogger.com/profile/07504398388569597105noreply@blogger.comtag:blogger.com,1999:blog-29438013.post-1825789046895713602009-07-11T13:04:11.251-04:002009-07-11T13:04:11.251-04:00Great article rafael...I have a scenario where the...Great article rafael...I have a scenario where the dev server and the prod server for my packages hapeens to be the same. How would I manage my package configurations?Unknownhttps://www.blogger.com/profile/01668143629164347364noreply@blogger.com