Viewing 15 posts - 12,481 through 12,495 (of 13,849 total)
Is the PK an IDENTITY field? If so, you'll have to enable IDENTITY insert.
October 21, 2009 at 1:22 pm
bitbucket-25253 (10/21/2009)
Phil Parkin
You are wrong in thinking that SSIS cannot import values from Excel which are the result of calculations. I just tried this and it works fine.
Phil did...
October 21, 2009 at 10:05 am
I just expanded my testing to include cells populated via drop-down and these worked fine too. So there must be something more to this ...
October 21, 2009 at 9:51 am
bitbucket-25253 (10/21/2009)
If they do then
2. Check Excel help for "Replace a formula with its result"
Unfortunately the only...
October 21, 2009 at 9:38 am
That's too complex for anything but the Script Component - I suggest you concentrate your efforts there.
October 21, 2009 at 9:02 am
Except for your post, the word 'wizard' appears nowhere in this thread.
October 21, 2009 at 5:17 am
Siddharth Mehta (10/21/2009)
October 21, 2009 at 5:14 am
Siddharth Mehta (10/21/2009)
Step 2: Use the option of Edit Top 200 rows by right-clicking the table in SSMS
Step 3: Paste the data,...
October 21, 2009 at 5:10 am
I suspect that you need to use SQL syntax which is supported on DB2.
Check here and search for INSERT as a possible resource to get you through this.
October 21, 2009 at 1:28 am
You have left the reader to face unnecessary challenge number one: "What's the question?" It would appear to be: "How do I get the data to transfer too?" But as...
October 18, 2009 at 11:46 am
I just (yet again) ran into this Excel 'feature' and it managed to irritate me just as much as it always has.
This time, however, I tried a different solution: I...
October 17, 2009 at 4:35 am
So you are adding data to an existing table using SSIS and it is in this table that you would like to auto-increment department?
Why not use an IDENTITY field on...
October 17, 2009 at 4:15 am
Use an Expression to set the Filespec (from memory) property, rather than typing the variable stuff directly in to the property ...
October 6, 2009 at 1:59 pm
Viewing 15 posts - 12,481 through 12,495 (of 13,849 total)