Viewing 15 posts - 4,801 through 4,815 (of 13,872 total)
Note that it's been called SSIS, not DTS, since 2005.
January 17, 2018 at 2:01 pm
So I suggest building your SQL dynamically via a package variable with an Expression and using that as the source for the ExecSQL task.
January 17, 2018 at 1:13 pm
You cannot run anything more than very simple SQL against an Excel connection. The parameter stuff is probably causing the problem.
January 17, 2018 at 12:59 pm
January 16, 2018 at 1:53 pm
Select ContactID, Name
FROM dbo.TableA
IN Lookup Transformation I need to pull...
January 15, 2018 at 7:35 am
January 15, 2018 at 5:27 am
So how do you determine which years are required for each ID?
January 12, 2018 at 3:07 pm
chrisjgreen08 - Friday, January 12, 2018 2:26 PMID comes from a table called 'Name'. It's a unique VARCHAR field.
OK, and does this...
January 12, 2018 at 2:29 pm
Any thoughts on a...
January 12, 2018 at 2:24 pm
January 12, 2018 at 7:52 am
January 11, 2018 at 5:01 am
I have a txt file which has several lines. below is a sample...
December 19, 2017 at 6:30 am
IF @ID = NULL
to
IF @ID IS NULL
You...
December 18, 2017 at 2:16 pm
Viewing 15 posts - 4,801 through 4,815 (of 13,872 total)