Tag: ssis

Difference between InitialCatalog and Database Name

I’m amidst “parameterizing” a connection in my package and I’m confused: I’m trying to set the database name but there are two options: 1- InitCatalog Name and 2- Name: Here is what my connection looks like: And my parameter options are (as mentioned 1- InitCatalog Name and 2- Name): and So my question is: which […]

SQL Server Data Tools in VS Community

This question already has an answer here: Using SSIS BIDS with Visual Studio 2012 / 2013 3 answers

Visual Studio 2012 – Deleting multiple SSIS Column Mappings in Data Flow Task

Is there a way to remove all column mappings in a SSIS data flow task in one step? In the example below, if I wanted to remove all the mappings I would have to individually click each arrow (using ‘ctrl+click’) and then hit the ‘delete’ button. This is not ideal if I have a table […]

Call SSIS package from a stored procedure

How can we call an SSIS package from a stored procedure and pass it a parameter?

SSIS 2008 task dependency configuration

I have a package that before any ETL happens it checks source tables to ensure they exist. If they do not exist, it sends me an email via send mail task then waits 30 mins via execute sql task, before trying again via for loop container. I’m trying to configure this package so if it […]

Import EventViewer error logs to sql server table using Powershell or SSIS

Is there is any way to import the error logs from event viewer to SQL table and schedule a job on daily basis. I would like to use a powershell script or SSIS package.

ssis – No value given for one or more required parameters

I am working with SSIS 2008. i am getting error on sql task editor query as Error: Executing the query “SELECT SUBSTRING(?, 8, 2) + SUBSTRING(?, 10, 2) +…” failed with the following error: “No value given for one or more required parameters.”. Possible failure reasons: Problems with the query, “ResultSet” property not set correctly, […]

SQL Server 2012 & SSIS – need to get the Microsoft.SQLServer.DTS.Design.DLL

I need to get the Microsoft.SQLServer.DTS.Design.DLL in the C:\Program Files (x86)\Microsoft SQL Server\110\SDK\Assemblies folder installed somehow. I installed almost everything possible, like Data Tools for Visual Studio 2012, SQL Server BI, Client SDK etc. but it is still missing. What do I need to install?

Changing column from source to column with unique key constraint – SSIS

I am fairly new to SSIS and I am doing small data migration. I have column in my destination database col1 which has Unique Key constraint and the data is in “xxxx01” -form. What I need to do is to shorten the source data from col2 to four first characters (xxxx) and add running number […]

How to make SSIS truncate numeric field in Flat File Destination

I’d like some advice about handling truncation issues in SSIS. I have a column Col1 which is MONEY in a table. I’d like to output that to a text file (fixed width, ragged right). In the output file, the column which holds Col1 must only be 8 characters wide. In the OLEDB Data Source, Col1 […]

MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.