Tag Info

New answers tagged

2

SSIS code behind is actually a XML value and all components of package will be represented as XML node values within it.This XML can be parsed to identify if it has a reference for our searched table or column. Finding SSIS Packages having References to a Table or Column will help you.


1

Yes you can. In you expression you can use: "+@[User::(variable name)]+" More info: https://anothersqlgeek.wordpress.com/2013/03/28/ssis-dynamic-connections-part-1/


0

In the 'Data Conversion Transformation Editor' within the 'Data Flow', I had to convert the column as string[DT_STR] and set the Error and Truncation to 'Ignore Failure'.


0

Your question is vague, but here is a blog post from Matt Masson on how to get started with CDC and SSIS http://www.mattmasson.com/2011/12/cdc-in-ssis-for-sql-server-2012-2/


2

You have to deal with the unicode replacement character by calling it what it is: Row.Description = Row.Description.Replace(NCHAR(65533), "a") EDIT: I apologize as I first gave you a pseudo-SQL Server solution, but with some additional research learned that SSIS behaves a little differently. I'm linking my source that gives multiple solutions, and for an ...


2

If I'm understanding you correctly what you're looking to do should be quite simple. I'm not entirely sure how you're setting @date1 but for this to work you will need to set that as a SSIS variable and for this example I'll assum it's a date. Then you need to create your query as a variable and then set it as an expression like so. Then you set your ...


2

It's not possible to bind column names to variables, but you can achieve similar results by using dynamic SQL. DECLARE @datetxt varchar(10) = '2015-01-01' DECLARE @sqltxt nvarchar(1000); SET @sqltxt = N'SELECT dateAdd(second, 1, ' + @datetxt + ') AS StartTime FROM Termination_Call_Detail' Exec (@sqltxt)


0

this is just a warning.your package will execute anyway. this comes up because the length of source variable and the destination variable is not same. to resolve this warning,right click the destination source,select show advance editor option,select the input and output properties tab,expand the input and output variable and check the length.if they are ...


1

JShean, I am with the MarkLogic product team, I saw your question and wanted to point you to some information. In general, mlcp is the most efficient way to load documents into MarkLogic, though I know many customers don't like dumping all the data to disk. Have you considered doing the process in batch - dump a certain set to disk, use mlcp to load and ...



Top 50 recent answers are included