Viewing 15 posts - 1,456 through 1,470 (of 2,612 total)
You can do this a few ways.
You can use a lookup component in your dataflow. If take the Lookup Failure output (the Red arrow) and use this as the...
May 29, 2008 at 10:29 am
You can configure if indexes keys, etc. are to be replicated. If they have not been selected, that would account for the difference. In addition, if your source...
May 29, 2008 at 7:29 am
SSIS does not handle column definitions changing well (or really at all). As you may have noticed, every component in your data flow has the definition of it's inputs...
May 29, 2008 at 7:23 am
The SMTP server logs will depend on the SMTP server you are using. I would suggest you talk to the person who configured the SMTP server.
The message queue is...
May 29, 2008 at 5:44 am
There is a sid and a login time in sysprocesses. The login time stays constant when a connection is reinitialized without being disconnected, and I think the sid stays...
May 29, 2008 at 5:36 am
I do this a lot and have never seen the behavior you are describing. Check the data just before the OLEDB Destination component (after the SCD component) using a...
May 29, 2008 at 5:27 am
That is not an error, it is a message. You will get this message when a mail message is successfully sent to the service broker. In database mail,...
May 29, 2008 at 5:23 am
If it is working in the IDE, the variable mapping is ok. This is a permissions issue, or a relative folder issue.
Check permissions first - log in with the...
May 29, 2008 at 5:18 am
Change the encryption to DontSaveSensitive or EncryptSensitiveWithPassword - these options do not depend on the NT Login.
May 29, 2008 at 5:12 am
On the other error, this case statement:
[font="Courier New"]CASE maxsize WHEN -1 THEN ''Unlimited''
else
maxsize end[/font]
is trying to return maxsize (an integer) or...
May 28, 2008 at 2:18 pm
Ignoring the why, I just converted the "8" into a BIGINT to get the multiplication result to use the BIGINT data type rather than INT and the query works fine.
[font="Courier...
May 28, 2008 at 2:15 pm
You can also use a check constraint to handle the inserts and updates rather than a trigger. You will need a trigger on at least one of the tables.
This...
May 28, 2008 at 2:11 pm
The procedure master..xp_varbintohexstr is not a system extended stored procedure in SQL 2005. Is this something you added?
May 28, 2008 at 2:09 pm
Use CAST to make it a VARCHAR and then convert it in SSIS with a derived column or data conversion component.
The Oracle Clients (at least all of them through 10g)...
May 28, 2008 at 2:06 pm
Yes, you can do this.
I think there are instructions on Microsoft's website. You can just search on google and I am sure you will find some. The reality...
May 28, 2008 at 2:01 pm
Viewing 15 posts - 1,456 through 1,470 (of 2,612 total)