Viewing 15 posts - 76 through 90 (of 805 total)
It's weird that it is coming back as NText. What are the values in the first row of the document? Should normally come back as unicode. (DT_WSTR)
August 20, 2008 at 3:37 am
I would rather do it the other way. Use a Excel connection.
Here's why:
You are invoking SSIS who runs a SLQ task who asks SQL to open the excel file who...
August 20, 2008 at 2:21 am
Can you use Union all as a destination or Konesans Trash Destination.
Is it infact the destination that has the problem or something from your source?
August 20, 2008 at 1:24 am
SSIS Config files. Menu > SSIS > COnfig...
August 20, 2008 at 1:22 am
You are using SQL to read from excel. The Excel source reads directly from the file, not via SQL.
Either change your source to be oledb source and use your existing...
August 20, 2008 at 1:19 am
With that amount of rows, I would load all the delete ID's into a table using a dataflow, then using a sql task, I would run a SQL script that...
August 20, 2008 at 1:15 am
My first thought would be to create a copy of your database(s) and write a script to create triggers on all tables. Write out any changes from database A to...
August 20, 2008 at 1:09 am
Odd. What was the full error message? The above seems truncated.
August 19, 2008 at 10:05 am
Either look in BOL on how to change select permissions or to to the security section on this site and ask there as it is not now a ssis issue.
August 19, 2008 at 10:03 am
bang.prashant (8/19/2008)
hiit is better if you would develop package and give it to me.
...
you can send ssis package to my id bang dot prashant at gmail dot com
thanks
bang
That is...
August 19, 2008 at 10:01 am
Well, so far you are on the right track.
Deletes:
You would have to use a OLEDB Command for that. Depending on number of rows (How many are the BTW) this...
August 19, 2008 at 9:51 am
A config file is just that: SSIS configuration settings.
To create one,: Menu > SSIS > Configuration. Click add and follow the wizard.
It does not add it to your solution. You...
August 19, 2008 at 9:44 am
Sure:
Variable Expressions: here are 31,500 details: http://www.google.co.uk/search?hl=en&rlz=1B3GGGL_enGB259GB259&q=ssis+variable+expressions&btnG=Search&meta=
3rd result is a good one.
As for renaming:http://www.google.co.uk/search?q=ssis+rename+file+%22file+system+task%22&sourceid=navclient-ff&ie=UTF-8&rlz=1B3GGGL_enGB259GB259&aq=t
In particular, http://rafael-salas.blogspot.com/2007/03/ssis-file-system-task-move-and-rename.html
A little leg work... A quick google.
If you...
August 19, 2008 at 9:40 am
It means you do not have permissions. What was the error? (Detailed please)
August 19, 2008 at 9:29 am
Are you connecting to SQL 2k with the same credentials? eg sa?
can you select * From sysjobs on the smdb from within ssis?
August 19, 2008 at 9:01 am
Viewing 15 posts - 76 through 90 (of 805 total)