Viewing 15 posts - 4,771 through 4,785 (of 11,678 total)
Sure.
SELECT 'Nothing' FROM myTable;
Et voila, the row still has the value A.
September 25, 2013 at 2:05 am
Ah ok, so you want to update a value to a new value and then back to it's old value.
It seems rather pointless, are you sure that's what the interviewer...
September 25, 2013 at 1:48 am
UPDATE myTable
SET City = CASE WHEN City = A THEN B
...
September 25, 2013 at 1:25 am
There's no built-in task in SSIS that can do this for you, so you probably need to resort to .NET scripting.
September 25, 2013 at 1:12 am
You need to specify a new folder yourself.
You can log into the SSIS service and create it there.
The "/" is the root folder of the SSIS service.
September 25, 2013 at 1:10 am
Are you sure you have SSIS installed, and if yes, which version?
September 25, 2013 at 1:08 am
September 25, 2013 at 12:44 am
Is this a homework question?
Also, please provide table DDLs and sample data please.
September 25, 2013 at 12:42 am
Shaun2012 (9/24/2013)
I'm using SQL 2008 r2, both in prod and dev.
I am using XML config file.
My project has 5 packages.
I updated all the passwords but when I reopen, I...
September 25, 2013 at 12:34 am
Maybe you should try an UPDATE statement instead?
Also make sure ColA is a varchar column, otherwise you won't be able to store the string values.
(and convert ColA to int before...
September 24, 2013 at 2:49 pm
I believe it will still create it anyway.
If the empty file is such a problem, you can always delete it right after the data flow. Add a row count component...
September 24, 2013 at 2:46 pm
AndrewSQLDBA (9/24/2013)
September 24, 2013 at 2:07 pm
Maybe the integrated logging and event handling was used?
Or the previous guy liked the graphical approach of SSIS?
September 24, 2013 at 1:56 pm
Which version of SSIS?
There are a lot of different options on how to deploy packages.
These two articles give an overview:
SSIS Deployments with SQL Server 2012[/url]
Which errors do you get?
September 24, 2013 at 1:54 pm
Viewing 15 posts - 4,771 through 4,785 (of 11,678 total)