Viewing 15 posts - 3,466 through 3,480 (of 11,678 total)
Grant Fritchey (3/21/2014)
Didn't we already have this exact conversation earlier?
Yup.
March 21, 2014 at 5:13 am
Lempster (3/21/2014)
You could also use a T-SQL MERGE...
March 21, 2014 at 5:07 am
I think ? is a placeholder for a non-printable character, so you won't find it when you search for it.
Maybe you should inspect the data using a hex editor, to...
March 21, 2014 at 4:39 am
Why are you not using the cache in the lookup component?
March 21, 2014 at 4:24 am
Sushant Yadav (3/21/2014)
Yes I have configured the same package to run from sql agent.It was executing successfully before last two days.
Does the user executing the job have the required permissions?
March 21, 2014 at 4:04 am
anilraj0309 (3/21/2014)
Koen Verbeeck (3/21/2014)
What is the protection level of the package?Generally you would store connection information indeed in a configuration table.
Hi Koen,
Protection level is : EncryptSensitiveWithUserKey
will this make any difference?...
March 21, 2014 at 3:32 am
SCD Wizard has terrible performance for the updates as it uses the OLE DB command.
You can run the wizard and replace the OLE DB command with an OLE DB Destination,...
March 21, 2014 at 3:30 am
Duplicate post. Original thread with replies can be found here:
http://www.sqlservercentral.com/Forums/Topic1553367-148-1.aspx
March 21, 2014 at 3:23 am
What is the protection level of the package?
Generally you would store connection information indeed in a configuration table.
March 21, 2014 at 3:22 am
yuvipoy (3/21/2014)
Koen Verbeeck (3/21/2014)
You don't need to know how SQL Server works internally just to create a...
March 21, 2014 at 2:42 am
If the maximum value is lower than the maximum int value, then choose int.
You don't need to know how SQL Server works internally just to create a table.
If you are...
March 21, 2014 at 2:20 am
What is the source for your report? A database or a cube?
March 21, 2014 at 2:07 am
Which character are we talking about?
Can you show us the query you wrote with the LIKE operator?
March 21, 2014 at 2:05 am
Sushant Yadav (3/20/2014)
I am Getting following error when I execute SSIS package through SQL agent job.
Executing the query "DECLARE @errorcode INT DECLARE @ErrorDesc Varchar(..." failed with the...
March 21, 2014 at 2:03 am
What is the range of values you are going to store?
This is the only thing you need to look for. Performance differences, if there are any, will most likely be...
March 21, 2014 at 2:00 am
Viewing 15 posts - 3,466 through 3,480 (of 11,678 total)