Tag Info

Hot answers tagged

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)


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

I found an article about that, the version is to HANA 4.1. To move data from SQL Server to HANA, you can use SAP BODS in version 4.1 SP1 brings improved migrate with an assistant. Other methods such as: Sybase replication server.


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/


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 ...



Only top voted, non community-wiki answers of a minimum length are eligible