SQL Server Integration Services, an ETL tool sold by Microsoft and bundled with SQL Server versions since SQL Server 2005.

learn more… | top users | synonyms

1
vote
1answer
786 views

How do I set up a Derived Column Transformation to get row number in SSIS 2014?

I am trying to import a ragged right flat file. I am wanting to import the file as one column and used Derive Column Transform to add a row number to each row. I would like to end up with a column ...
1
vote
1answer
784 views

SSIS Packages with SQL Server Express 2008 R2

I understand from various questions [1] [2] that SQL Server Express 2008 R2 doesn't support SSIS packages and that there's only primitive support for ad-hoc data imports / exports. I have already got ...
1
vote
2answers
292 views

TSQL vs SSIS Lookup

I was trying to find some well performing Tsql equivalents for the SSIS Lookup component. Especially for Fact table loading. After few different query patterns the most obv performed the best: ...
1
vote
1answer
3k views

SQL Server 2012 Agent Job not providing full failure message for SSIS Packages

(this was also posted at http://www.sqlservercentral.com/Forums/Topic1576641-2799-1.aspx) We are having an issue with 2012 SQL Servers not reporting why a job has failed, this is happening for jobs ...
1
vote
1answer
226 views

How to reinstall SQL Server Integration Services I've deinstalled from a Production server by mistake

In deinstalling a named instance of SQL Server 2012 from a Production server, inadvertantly, I selected SSIS as a product to deinstall. Now, I need to reinstall it with the least disruption possible. ...
1
vote
2answers
77 views

SSIS via Import Wizard SQL Server 2008 R2

I have a flat file i need to import into SQL. For a lot of boring reasons, I curently don't have access to use BIDS, only the import wizard in SSMS. The flat file looks sort of like: A 2 B ...
1
vote
3answers
7k views

How to move a SQL Agent Job to another Server?

I'm moving from SQL Server 2005 to SQL Server 2008R2, and I see there is one job in the SQL Server Agent Jobs that I need to move but I see it also in the SSIS---> Stored Packages\MSDB\File ...
1
vote
1answer
147 views

Extracting text from a column

I want to import data from Excel into an existing table in a SQL Server database. I have a column like Gender and the values are Male and Female in Excel. I want to insert only the first character ...
1
vote
1answer
607 views

SSIS 2012 Ftp parallel/asynchronous multiple file download

Any help would be appreciated with either scenario. if Are there any settings available to download multiple files in parallel from an FTP server? else If not, I guess I'll just roll my own via ...
1
vote
1answer
223 views

how to deal with a SSIS 2005 validation error in a script component

Within a script component, a strange error occurs. the (vb.net) code leads to build succeeded as mentioned, build done BUT and that's not really awesome (and, yes, design script was clicked): ...
1
vote
1answer
286 views

How does one select the histogram / scatterplot / etc. Data Viewers in SSIS 2012

I have a data flow task in SSIS 2012 and have created a flat file source and an OLE DB connection destination. I can select the data flow path between them as in earlier versions of SSIS and I can ...
1
vote
1answer
10k views

How to override SSIS 2008 package config file path?

I have an SSIS 2008 package with a single configuration named Config. I would like to use the dtexec /SET switch to change the path of the config file that it uses so our developers that build the ...
1
vote
1answer
995 views

uninstalling SSRS and SSIS from clustered SQL Server 2008 R2 SP1

Due to the security recommendation, i will need to uninstall the unused SSRS and SSIS component from a production cluster SQL Server 2008 R2 SP1, so what is the caveats and what do I require to do to ...
1
vote
1answer
470 views

How do I handle importing high amounts of transaction data into application DB?

For the moment, this is a hypothetical question. I've got a database that has a high level of transactional data coming into it. I also have a database that supports my website (my application ...
1
vote
1answer
18 views

How to export SSIS (SQL Server Integration System) packages to third party data source

I want to export SSIS packages into a HANA databse. Please guide me through the exact steps to achieve this.
1
vote
1answer
21 views

SSIS Package Security

I am writing a Package for one of my client according to his requirements. Package development is totally complete now time is to protect it with some security. Is this possible I encrypt all the data ...
1
vote
1answer
63 views

SSIS Transaction Problem

I am trying to use SQL transaction with my SSIS package so if any error comes changes are rollback. I am using an "Sequence Container" in Control Flow for this and setting its "Transaction Option" to ...
1
vote
1answer
417 views

How to use HTTP Connection Manager in Script Component? (Not Script Task)

I'm trying to perform the same scenario as in the following link; Create a SSIS Script Component as a Data Source that uses a pre-existing HTTP Connection Manager to retreive a page with GET and emit ...
1
vote
2answers
908 views

SQL ssis delete imported rows from source table

I have setup a simple SSIS package that copies data from a source table to a destination table which works. I would like to get the package to also delete the data in the source table that has been ...
1
vote
1answer
136 views

Difference in number format (comman and dot) on SSMS and SSIS

I have a numeric(5,2) field on my SQL Server database. When I run the query, the number on that field appears with . (dot) separator. However, when I preview the query on SSIS, it appears with ...
1
vote
1answer
168 views

Granting permissions to SSIS for developer

I installed SSIS a couple of months after installing SQL Server 2014. I granted permissions to users per MSDN and rebooted SSMS and SSIS. I can login remotely from my client without issue, but have ...
1
vote
1answer
434 views

SSIS Package Validation Error email task when attaching file created by previous task

While running in debug mode an SSIS package I get the folowing error. "file ... does not exist ...", but the file is created by a task earlier in the process, so most probably it will exist at ...
1
vote
2answers
2k views

Unable to connect to FTP server using “FTP Connection Manager”

I'm trying to setup an SQL agent job to use my SSIS package. The package contains an FTP task that is failing. I'm getting the following error in both the job history and logging that I've setup (Log ...
1
vote
1answer
300 views

Why is Excel File Opened Exclusively By Another?

I'm creating an SSIS package to loop through a series of Excel files (.xls). I create my while loop container and then create my data flow, which includes an Excel source. When I edit my Excel ...
1
vote
2answers
258 views

script task sssis file extension is missing?

Hi I have problem with script task C# I create I have to prefix log file with date but my problem is not adding file extension log file is log_yyyy_MM_dd without extension I want ti extension log ...
1
vote
1answer
421 views

Error when trying to deploy SSIS package

I am trying to deploy my 2012 SSIS project to the Integration Services catalog on the SSIS server (also 2012). I am getting the error below. I checked that there is plenty of space in SSISDB and ...
1
vote
2answers
81 views

best way to deal with imperfect xls source file that needs to be imported into SQL via SSIS

The data is formatted like this: Date Type Account 1/1/14 AAA 111 112 113 BBB 114 115 ...
1
vote
1answer
461 views

Why Does SSIS Oracle Source by Attunity return DT_WSTR for Oracle CHAR(1) Column?

Using SSIS 2012 and Microsoft SSIS Connector for Oracle by Attunity v. 2.0. When I add an Oracle Source for a particular table, it is setting the data type for an Oracle CHAR(1) field to DT_WSTR. I ...
1
vote
1answer
931 views

SSIS: Get Date for Day of the Week

In SSIS, how do I get the date for a specific day of the week? For example, how do I get last Sunday's date? I assume I have to do some subtraction on the day-of-week, but not sure: DATEADD("d", ...
1
vote
1answer
173 views

How to divide data per client from a single database?

I am looking for best practices to separate data from a single database into multiple client specific databases. Currently my application dumps data for all the customers into single database and I ...
1
vote
1answer
314 views

Copying Data to Other Database Tables

Should I use SSIS or stored procs to copy data from a number of database tables on one server to database tables on a different server? Each table's structure is identical to the destination server ...
1
vote
3answers
5k views

SSIS Package Truncation may occur due to inserting data from data flow column

I've a dataflow in SSIS 2008. It reads the data from flat file and inserts in to database. The flat file is CSV. For some reason, all the fields in flat file connection manager seems to have 50 ...
1
vote
1answer
520 views

SSIS FTP Sending Blank Files

I'm supporting an existing data interface that is a series of SSIS packages (SQL 2008 R2) for sending and receiving data with a third party. The communication is being done through FTP, and it uses a ...
1
vote
1answer
241 views

Using OLE DB Source SQL command vs desinging the query using the object tools

In SSIS, we can use the OLE DB Source SQL command to run a T-SQL script on the database and then use the output as the source. For example the a complex query can be wrapped in the OLD DB source SQL ...
1
vote
1answer
162 views

SSIS Suddenly Requires DCOM Permissions

I have recently deployed some SSIS packages. I made a job to run them one after another. However, I am now allowed to use MSDTC. So I chained the jobs together like I have done before, but now I am ...
1
vote
1answer
879 views

How to avoid log space error while executing SSIS packages?

I'm executing ssis package with more than 70 million data's. But I'm facing issue as log space full error message while executing the package. Is there any option to resolve this issue?
1
vote
1answer
567 views

Connect to SQL Server 2012 Database from 2008 Agent Job containing 2008 SSIS Package

I'm planning the rollout of SQL Server 2012. My client has a number of SQL Server Integration Services (SSIS) packages currently deployed to SSIS 2008 and consumed by SQL Server Agent Jobs defined on ...
1
vote
1answer
736 views

SSIS data transfers between two remote servers

Let's say I have three servers, ServerA, ServerB, and ServerC. ServerA has the production database, ServerB has the staging database, and ServerC has the data warehouse. I've created an SSIS package ...
1
vote
2answers
467 views

How do I run a SQL Server 2005 job on Windows 7?

I have Windows 7 and SQL Server 2005 Version 9.00.1399. I can successfully create an SSIS Package, however I am unable to execute it successfully as a scheduled job. When I run the job, SQL Agent ...
1
vote
1answer
175 views

ssis delete database on error

I'm writing an ssis package that imports a number of access databases nightly. Each database has the potential to have a slightly different schema. Since I'm creating the tables than doing a direct ...
1
vote
1answer
277 views

Sending SQL Server query as CSV via e-mail

Currently I'm using SSIS w/ a hacky solution to get around it not supporting auth on SMTP servers. Is there a better way I can save a query to a CSV file, then mail it as an attachment? Thanks
1
vote
2answers
2k views

Flat file manager TextQualifier not working

I've a CSV text file which contains col1,col2,col3 "abc,cdef",a,b When I use the Flat File Source and preview the a bc,cdef appears on first column. But when i run and view the result in ...
1
vote
1answer
22 views

Simple SSIS Package Failed User does not exist or has not permission

I created and build SSIS Package with "Transfer SQL Server Objects Task". I Copied the package.dtsx to network folder with permissions set to everyone. I created the SSIS Job where i set path ...
1
vote
0answers
35 views

Failed to deploy the project. Try again later. (Microsoft SQL Server, Error: 27118)

I try to deploy new version of existing SSIS project into Intergration Service Catalog and getting error: "Failed to deploy the project. Try again later. (Microsoft SQL Server, Error: 27118)" ...
1
vote
0answers
28 views

SSIS - The value could not be converted because of a potential loss of data, runs fine in BIDS, not on the server

The value could not be converted because of a potential loss of data I'm getting this error when running an SSIS package from a server job. Normally this is some sort of type error, but I can't ...
1
vote
0answers
18 views

Is There A Benefit To Using SSIS Packages Over Linked Servers?

We have a new head DBA, and he has decided he does not want us to use linked servers for development moving forward. In addition he would like to replace all existing code that uses linked servers to ...
1
vote
0answers
9 views

How can I prevent SMB digital signing from killing SSIS performance?

My company recently turned on SMB digital signing on the Windows 2012 r2 server that runs SSIS. This has had a severe impact on data transfer performance. The security team did this and I can't get ...
1
vote
0answers
77 views

how to disable and enable SSIS package using commandline?

I have a scenario where SSIS packages are deployed at the customer's site and they have some data issues. Because of this we are developing new packages to fix the corrupted data. When my new ...
1
vote
0answers
157 views

Why does an SSIS package fail when executed from the IS Catalog?

When executed via the SQL Server Agent under the same user context, is there any reason a package would successfully run when using the file system (i.e. DTExec.exe), but fail to execute when launched ...
1
vote
1answer
56 views

Automatic database restore fails as cannot find file

A while back I asked for help automating a database restore using a backup file provided from another server: Automatically restore SQL Server database from file from another server. I'm pleased to ...