Viewing 15 posts - 4,876 through 4,890 (of 13,877 total)
I am creating a SSIS project that will consist of a parent package with a...
November 28, 2017 at 6:09 am
November 27, 2017 at 11:03 am
November 27, 2017 at 10:59 am
November 27, 2017 at 10:26 am
As you've been so helpful in posting all the DDL, sample data and desired results, I've written the solution out for you below.
Note that it is almost a direct...
November 27, 2017 at 10:17 am
myukas - Monday, November 27, 2017 8:59 AMnot familiar with that how does it work
Presumably you know how to automate running of...
November 27, 2017 at 9:12 am
November 27, 2017 at 8:49 am
myukas - Monday, November 27, 2017 8:09 AMIs there an easy way to do schema only exports in mssql
You could extract...
November 27, 2017 at 8:16 am
I want my numbers to be converted from a column which is of nvarchar(100)...
November 27, 2017 at 7:34 am
November 26, 2017 at 6:25 pm
I am a newcomer to the world of TSQL and was wondering if someone...
November 26, 2017 at 10:08 am
They look like lineage Ids to me. You should be able to track down the columns they belong to by opening the package in SSDT. Have a read
November 23, 2017 at 7:36 am
My preference would be to put the additional stuff into another database & live with the dependency.
I would, however, make sure that this was a one-way dependency...
November 21, 2017 at 1:37 pm
November 20, 2017 at 12:07 pm
Are you using a Fixed Width flat file destination in SSIS? You should be able to define all of your column widths there, without the need for any fancy REPLICATE...
November 20, 2017 at 10:51 am
Viewing 15 posts - 4,876 through 4,890 (of 13,877 total)