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 […]
This question already has an answer here: Using SSIS BIDS with Visual Studio 2012 / 2013 3 answers
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 […]
How can we call an SSIS package from a stored procedure and pass it a parameter?
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 […]
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.
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, […]
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?
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 […]
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 […]