Viewing 15 posts - 1,756 through 1,770 (of 11,678 total)
Unless using Integration Services (which is a metadata control freak), normally things won't break that easily.
SQL Server will just use implicit conversions everywhere, which may impact execution plans and the...
October 7, 2014 at 12:45 am
HanShi (10/7/2014)
October 7, 2014 at 12:43 am
Great question, I didn't know about this feature.
October 7, 2014 at 12:40 am
There is no backwards or forwards compatibility in SSIS.
If you need packages for SSIS 2008, you need to develop them in Visual Studio 2008 (aka BIDS).
October 6, 2014 at 1:01 pm
jjr.123 (10/6/2014)
So can I use a script task after DFT do formatting.
That's an option yes.
October 6, 2014 at 12:52 pm
You'll have to use .NET to do this. SSIS cannot do this out of the box.
October 6, 2014 at 7:48 am
You can execute a package stored in the SSIS catalog using stored procedures:
Deploy and Execute SSIS Packages using Stored Procedures
You can execute the package synchronously using a parameter:
October 6, 2014 at 4:40 am
Which version of SSIS are you using?
In SQL Server 2012 and above, you can start packages using stored procedures.
Maybe you can implement some restart machinism there.
October 6, 2014 at 4:28 am
ChrisM@Work (10/6/2014)
Koen Verbeeck (10/6/2014)
ChrisM@Work (10/6/2014)
Looks to me like an error in the query:...
Good catch.
And that's why we use the SQL formatting people 😀
+1
Our little team's working with DB2. If you...
October 6, 2014 at 4:07 am
ChrisM@Work (10/6/2014)
Looks to me like an error in the query:...
Good catch.
And that's why we use the SQL formatting people 😀
October 6, 2014 at 4:02 am
ronan.healy (10/6/2014)
is there any way i can put a flat file destination as package run through.
what they want it to be...
October 6, 2014 at 3:34 am
HanShi (10/6/2014)
October 6, 2014 at 3:32 am
Not sure what your question is.
A derived column has only two outputs: a normal one (the green errow) and the error output (the red arrow).
So you can hook up a...
October 6, 2014 at 2:58 am
Interesting trick, thanks for sharing.
October 6, 2014 at 1:54 am
You cannot use sum on a text column. Is it possible to give some sample data and desired output?
October 6, 2014 at 1:51 am
Viewing 15 posts - 1,756 through 1,770 (of 11,678 total)