Viewing 15 posts - 76 through 90 (of 806 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)
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
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...
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
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?
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
August 20, 2008 at 1:24 am
SSIS Config files. Menu > SSIS > COnfig...
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
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...
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
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...
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
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...
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
August 20, 2008 at 1:09 am
Odd. What was the full error message? The above seems truncated.
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
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.
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
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...
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
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...
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
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...
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
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 still have trouble, post back.
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
August 19, 2008 at 9:40 am
It means you do not have permissions. What was the error? (Detailed please)
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
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?
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
August 19, 2008 at 9:01 am
Viewing 15 posts - 76 through 90 (of 806 total)