Welcome To Ask or Share your Answers For Others

Recent questions tagged SSIS

0 votes

482 views

1 answer

ssis - Expression Builder of Connection Manager not showing Variables

I'm having this exact same problem I've been looking aroung but this is the only place I've seen the same ... in there Am I missing something? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

943 views

1 answer

ssis - "Microsoft.ACE.OLEDB.12.0" cannot be loaded in-process on a 64-bit SQL Server

I can not find a solution for this error: The 32-bit OLE DB provider "Microsoft.ACE.OLEDB.12.0" cannot be ... 'SELECT * FROM [Table_nm$]'); See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

423 views

1 answer

ssis - How to Add the Result Set from a T-SQL Statement to a Data Flow?

I have a simple SSIS package, and I'd like to complicate it a little. Right now, it executes a stored ... the add, delete and update columns? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

410 views

1 answer

ssis more than 4000 chars

My source - Oracle ; Destination - SQL Server Requirement - I have to fetch empid's from destination ... more description about this issue See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

557 views

1 answer

ssis - How do I create a package that would copy all files from a given folder into a new folder?

I have one folder called 'Data' that contains all files with current date in filename like for example 'myfile 20-08- ... ". How can I do that? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

580 views

1 answer

ssis - 2 Data Flow Tasks Linking to one Execute SQL Task

I have two Data Flow tasks where only 1 of the 2 will execute. After either of these execute I want an ... success) going into a task? Thanks See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

966 views

1 answer

ssis - How to replace double quotes in derived column transformation?

I have flat file. I am loading data from flat file to source table using ssis.And one of the column has following ... ,"") but this doesnt work. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

540 views

1 answer

ssis - How to read a flatfile with lowercase thorn as the delimiter

I'm trying to read a flat file in SSIS which is in this format col1 t col2 t col 3 I'm using ... character with a SSIS supported delimiter, See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

573 views

1 answer

ssis - Insert a single row and return its primary key

In SSIS, How do I use the execute SQL task to insert a single row with no parameters and get the primary ... ImportData] (EndDate) VALUES (null) See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

676 views

1 answer

ssis - Microsoft.ACE.OLEDB.12.0 is not registered

I have a SQL Server job that runs monthly that runs in server. Job is using an SSIS package and is supposed ... .OLEDB.12.0 is not registered" See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

To see more, click for the full list of questions or popular tags.

...