Looks like you have the right idea in general and the link @Speedbirt186 provided has some good details but it sounds like there are a couple of nuances that I thought I might point out in regards to flow and variables. The foreach loop can assign the entire path or the file name or file … Read more
Solution: Set the property RetainSameConnection on the Connection Manager to True so that temporary table created in one Control Flow task can be retained in another task. Here is a sample SSIS package written in SSIS 2008 R2 that illustrates using temporary tables. Walkthrough: Create a stored procedure that will create a temporary table named … Read more
Welcome to Microsoft Marketing Speak hell. With the 2012 release of SQL Server, the BIDS, Business Intelligence Designer Studio, plugin for Visual Studio was renamed to SSDT, SQL Server Data Tools. SSDT is available for 2010 and 2012. The problem is, there are two different products called SSDT. There is SSDT which replaces the database … Read more
You can make use of the namespace System.Net.WebClient to make the Http request with the help of Script Task in SSIS. Following example shows how this can be achieved. The example was created in SSIS 2008 R2. Step-by-step process: Create a new SSIS package and create two variables namely RemoteUri and LocalFolder. Set the variable … Read more
Yes. You will want to use a Foreach File Container and then check the Traverse Subfolder option. Edit Apparently my answer wasn’t cromulent enough, so please accept this working code which illustrates what my brief original answer stated. Source data I created 3 folders as described above to contain files sample1.txt and sample2.txt C:\>MKDIR SSISDATA\SO\TEST\201304 … Read more
Here is how to set variables in the package from code – using Microsoft.SqlServer.Dts.Runtime; private void Execute_Package() { string pkgLocation = @”c:\test.dtsx”; Package pkg; Application app; DTSExecResult pkgResults; Variables vars; app = new Application(); pkg = app.LoadPackage(pkgLocation, null); vars = pkg.Variables; vars[“A_Variable”].Value = “Some value”; pkgResults = pkg.Execute(null, vars, null, null, null); if (pkgResults == … Read more
The code from @garry Vass, or one like it, is going to be needed even if you’re using SSIS as your import tool. Within SSIS, you will need to update the connection string to your flat file connection manager to point to the new file. Ergo, you need to determine what is the most recent … Read more
In SQL: select dateadd(d,36464,’1899-12-30′) — or thanks to rcdmk select CAST(36464 – 2 as SmallDateTime) In SSIS, see here http://msdn.microsoft.com/en-us/library/ms141719.aspx
In your Execute SQL Task, make sure SQLSourceType is set to Direct Input, then your SQL Statement is the name of the stored proc, with questionmarks for each paramter of the proc, like so: Click the parameter mapping in the left column and add each paramter from your stored proc and map it to your … Read more
I ran the SQL script in the question but didn’t encounter any errors. So, I am not sure what is causing the error in your case. However, if you have access to SQL Server Agent through SQL Server Management Studio. Here are the steps to create a job using the Graphical User Interface. Go to … Read more