No announcements
-
2 VotesIt's time for the TechNet Wiki SSIS "Great Guru Love-in"! You too can get some loving!
February at TechNet Wiki usually involves a lot of love... We love to read. We love to learn. We ...Sticky | 3 Replies | 175 Views | Created by XAML guy - Monday, February 09, 2015 9:16 PM | Last reply by Ed Price - MSFT - 32 minutes ago
-
42 Votes
FAQ - SSIS Information, Webcasts, Tools, Add-ons, etc...
To add to the list, simply contact one of the moderators around here, or post a reply to this thread. Microsoft Reference Material SQL ...Sticky | 39 Replies | 105169 Views | Created by Phil Brammer - Monday, November 26, 2007 5:55 PM | Last reply by Ben Gribaudo - Tuesday, September 02, 2014 1:38 PM
-
0 Votes
Passing Script variable to Package variable, ultimately used as fileName
Following an excellent post by Geplaatst door Joost, I put together a script which SHOULD populate a package variable, then use that variable as a file name. The Script code is as ...Unanswered | 2 Replies | 30 Views | Created by Michael Shorkey - 12 hours 3 minutes ago | Last reply by SSISJoost - 30 minutes ago -
2 Votes
It's time for the TechNet Wiki SSIS "Great Guru Love-in"! You too can get some loving!
February at TechNet Wiki usually involves a lot of love... We love to read. We love to learn. We ...Discussion | 3 Replies | 175 Views | Created by XAML guy - Monday, February 09, 2015 9:16 PM | Last reply by Ed Price - MSFT - 32 minutes ago -
0 Votes
How to Run SSIS Package through SQL AGENT Job
System.NullReferenceException: Object reference not set to an instance of an object. at ST_ecfa668f250a45e18c95639c9ffd64d4.csproj.ScriptMain.Main() --- End of ... -
0 Votes
Not able to Access Shared Folder from SQL Server using SSIS
I have created a OLE DB Connection and Created a Flat File Connection pointing to a Shared Folder Location. When i execute in BIDS, its ...Unanswered | 2 Replies | 37 Views | Created by CrazySam81 - 3 hours 39 minutes ago | Last reply by Visakh16 - 2 hours 38 minutes ago -
1 Votes
Get Variable (Excel Destination Path String) From Script Task to Use For Destination Path In Excel Destination Plus Object
I am dynamically crating excel reports and file names for data input for SSIS package. The following is my VB code for Script Task to copy and rename Excel template: Public Sub ...Unanswered | 2 Replies | 33 Views | Created by jsorrisone - 4 hours 47 minutes ago | Last reply by jsorrisone - 3 hours 24 minutes ago -
0 Votes
SSIS DTEXEC Memory Issue
I have 4 SSIS packages running on my Windows 2012/ SQL Server 2012 machine to load data from other LAN SQL Servers to local SQL Server database. Recently I ...Unanswered | 2 Replies | 44 Views | Created by AL.M - 7 hours 14 minutes ago | Last reply by AL.M - 4 hours 2 minutes ago -
0 Votes
Dts.Runtime LoadPackage exception
Hi all I am working with SQL Server 2012 and Visual Studio 2013. I have installed Integration Services Project Templates in Visual ...Unanswered | 4 Replies | 34 Views | Created by frank.uray - 17 hours 5 minutes ago | Last reply by Wendy Fu - 4 hours 21 minutes ago -
0 Votes
Package Variable Values in For Each Contaner
I have a For Each File Container that loops through Excel files, executing a child package for each file found. I am using the RowCount transform to log the number of rows at various points in a ...Unanswered | 4 Replies | 53 Views | Created by Dick Campbell - 19 hours 36 minutes ago | Last reply by Dick Campbell - 5 hours 13 minutes ago -
0 Votes
Import/Export wizard auto-generates all columns as DATE
Hi I'm trying to use the Import/Export Wizard as I used to, as a handy tool to figure out what a series of T-SQL statements (in an SSIS package) is doing - or, if I'm lucky, what on ...Unanswered | 4 Replies | 61 Views | Created by sebts - Wednesday, February 25, 2015 3:53 PM | Last reply by ArthurZ - 5 hours 19 minutes ago -
0 Votes
Export Fixed Width File
Hello I am exporting a fixed width text file and it works fine until the end users try importing it into there system. I have the format set to Ragged Right so it separates each record to its own row. ...Unanswered | 3 Replies | 49 Views | Created by Emanlee00 - 11 hours 32 minutes ago | Last reply by ArthurZ - 5 hours 23 minutes ago -
0 Votes
SSIS 2008 Package hangs on OLE Data Source - [SSIS.Pipeline] Information: Execute phase is beginning.
Hello All, My SSIS package hangs on an OLE Data Source with this message ' [SSIS.Pipeline] Information: Execute phase is ...Answered | 5 Replies | 49 Views | Created by MarkCovi - 13 hours 13 minutes ago | Last reply by Wendy Fu - 5 hours 59 minutes ago -
0 Votes
Create a new excel in every time SSIS package is executed
Hello friends, My requirement felt really simple at the begining but seems it might get complicated.... I have a requirement to load data into an Excel ...Answered | 19 Replies | 11616 Views | Created by Sweta Dutta - Thursday, March 26, 2009 11:53 AM | Last reply by jsorrisone - 7 hours 10 minutes ago -
1 Votes
Create a Script Task in c# against Sql Serveur 2008 R2
Hello, I am trying to create a package with C#,I having issues to create the script task.My code is : using System; using ...Proposed | 2 Replies | 69 Views | Created by vincent.diallonort - Wednesday, February 25, 2015 4:15 AM | Last reply by vincent.diallonort - 7 hours 50 minutes ago -
0 Votes
Please help me to understand Transaction option in SSIS container
Hi experts, I am confused about Transaction option in SSIS container, 1. Required - Start the transaction. What is mean that start ...Unanswered | 4 Replies | 80 Views | Created by DevBi - Thursday, February 26, 2015 6:22 AM | Last reply by Naarasimha - 7 hours 55 minutes ago -
0 Votes
Derived column conversion to Excel
My Ole DB query runs several functions that return decimal fields. My user wants these fields as numbers (simple) but also wants nulls to print if that's what the function returns. Since Excel doesn't ...Proposed | 7 Replies | 126 Views | Created by David Lazarus - Friday, February 20, 2015 3:41 PM | Last reply by David Lazarus - 10 hours 27 minutes ago -
0 Votes
weird question in SSIS 2012 package
hi folks: I've created a SSIS 2012 package in my local machine using Microsoft SQL Server Integration Services Designer Version ... -
0 Votes
Help with DELTA load
Hi all, I'm currently trying to analyze how to perform a delta load in our data warehouse. Does anyone have any usefull examples, white ...Unanswered | 3 Replies | 55 Views | Created by Yvanlathem - 23 hours 30 minutes ago | Last reply by Yvanlathem - 12 hours 20 minutes ago -
0 Votes
change capture
in ssis i have 2table, one has latest copy of data s whatever changes made for current date i have to capture that change and send on ...Unanswered | 1 Replies | 38 Views | Created by coool_sweet - 13 hours 35 minutes ago | Last reply by ArthurZ - 12 hours 44 minutes ago -
0 Votes
Loading Excel mixed type column,char value is null
I am trying to load Excel 2007 files into SQL server. I am using Access ACE connection and openrowset to open the sheet. Some columns are mixed type of numbers and chars and SSIS/ACE driver will ...Unanswered | 4 Replies | 784 Views | Created by MigrationUser 1 - Sunday, November 10, 2013 6:00 AM | Last reply by Patrick McDonald - 15 hours 16 minutes ago -
3 Votes
Not able to send file Using FTP in SSIS 2005
I am using SSIS 2005 I am trying to send file to ftp server using FTP task in SSIS but i am getting following error. Error Message-:An error occurred in the ...Answered | 19 Replies | 9522 Views | Created by sskulkarni - Wednesday, June 16, 2010 5:23 PM | Last reply by Equiman - 16 hours 15 minutes ago - Items 1 to 20 of 54367 Next ›
No announcements
