Viewing 15 posts - 10,021 through 10,035 (of 13,874 total)
DavidBridgeTechnology.com (4/3/2013)
This...
April 3, 2013 at 2:44 am
That's a nice technique Dwain, thanks for sharing.
April 3, 2013 at 1:27 am
arjundhilod (4/2/2013)
this is my 1st time i want to create SSIS package.Step is as below But i am using visual studio 2008 or sql server 2008 r2...
April 3, 2013 at 12:55 am
Confirmed - that should do it. Good luck.
April 2, 2013 at 9:37 am
rs80 (4/2/2013)
Just to make sure I've understood your approach:
1) In the data flow, I would load the data from the oledb source to the template.
2) Then I...
April 2, 2013 at 8:34 am
nk1526 (4/2/2013)
I am trying to split sentence into words and insert into table as each word as a separate row
This is just practicing test
for some reason I am not...
April 2, 2013 at 8:28 am
Why not archive the file (or the very old data in the file) rather than letting it grow?
April 2, 2013 at 7:25 am
Surely the ideal thing here would be to fix the CSV file so that positions are shown correctly? But I presume that change is not possible, for some reason?
April 2, 2013 at 5:28 am
What is an "assing point"?
Edit - ah, 'assign'!
April 2, 2013 at 4:18 am
If this is just a training exercise, fair enough. But this is not the best way to solve such a problem - in SQL Server, loops are used infrequently as...
April 2, 2013 at 1:24 am
I'm not sure about best practice, but as SSIS is so heavily dependent on design-time meta data, I try to avoid run-time meta-data tweaks where I can. I don't know...
April 1, 2013 at 8:08 am
Try adding a data viewer to ensure that the data values are exactly as you mentioned. Remember that you need to be case specific (I think). Leading or trailing spaces...
April 1, 2013 at 5:27 am
An alternative way of achieving is to leave the name of the Excel destination static, and to use the File System task immediately after the data flow to copy the...
April 1, 2013 at 1:04 am
Without actually setting this up for myself, I am not sure how much more help I can offer.
Do all of the spreadshhet files already exist?
Have you tried using breakpoints to...
March 28, 2013 at 12:29 pm
I'm using 2012 - maybe it's different if you are on an earlier version - hopefully it should be obvious, if you already have a connection configured.
March 28, 2013 at 8:11 am
Viewing 15 posts - 10,021 through 10,035 (of 13,874 total)