Viewing 15 posts - 121 through 135 (of 186 total)
Koen Verbeeck (3/8/2012)
Do you know upfront how many little files you need to create?
No idon't
March 8, 2012 at 10:11 am
Koen Verbeeck (3/8/2012)
What is your source? First it is a table, than it is a file.We need to know this or we can't help you.
I could not figure out how...
March 8, 2012 at 8:53 am
I created a file and has 1000 records now I need to split that file to numerous file having 99 records per file each. How can I do that in...
March 7, 2012 at 1:05 pm
Jack Corbett (3/7/2012)
Guras (3/6/2012)
The size of the log file is 24G and the database is internally fragmented. The total number of the VLFs...
March 7, 2012 at 7:02 am
The job has started to fail again ...once in a while...any pointers would be greatly appreciated. thanks
February 16, 2012 at 7:17 am
Changed it to...
Datediff(dd,receivedDate,getdate()) >= b.Days
AND Datediff(dd,receivedDate,getdate()) < b.Days + 5
January 26, 2012 at 9:28 am
Sorry , that was a typo....
Thank you so much for the reply. The query results data perfect!!!! Just the way it was supposed to. Have a wonderful day ahead....
January 26, 2012 at 9:25 am
SQLKnowItAll (1/5/2012)
Why are you concerned here... Are you experiencing performance problems or are you just digging?
Just digging...
January 6, 2012 at 7:00 am
Ninja's_RGR'us (1/6/2012)
But I'll go on a limb and assume it's much less than 1 and...
January 6, 2012 at 7:00 am
rfr.ferrari (1/5/2012)
how many time to execute the select command in table?
It takes about a second to return all the 361 rows.
January 5, 2012 at 2:05 pm
rfr.ferrari (1/5/2012)
how many row???what size in kbytes?
total number of rows - 361
I don't know how to find the kb.
January 5, 2012 at 11:01 am
"C:\\" + @[User::i_fileFormatList] + ".csv"
I receive the following error when I click the evaluate expression button
The dat type of variable User::i_fileFormatList is not supported as an expression
December 15, 2011 at 10:31 am
Thank you all! Now I am stuck in the final part which is creating the file name based on the package level variable. I created the connection string of the...
December 15, 2011 at 10:17 am
TedT (12/15/2011)
http://www.sqlis.com/sqlis/post/Looping-over-files-with-the-Foreach-Loop.aspx
Essentially, you:
1. Pass the values you want to loop through into a full record set
2. Map the record set to a variable
3. Reference the variable in your for...
December 15, 2011 at 9:17 am
Thank you Ted for the reply. In the link that you have provided it is showing how to loop through the files in the folder. But I need to...
December 15, 2011 at 9:01 am
Viewing 15 posts - 121 through 135 (of 186 total)