No announcements
-
1 VotesWho will be announced as the next SSIS Guru? Read more about April 2018 competition!!
What is TechNet Guru Competition? Each month the TechNet Wiki council organizes a contest of the best articles posted that month. This is your chance ...
-
48 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 | 132945 Views | Created by Phil Brammer - Monday, November 26, 2007 5:55 PM | Last reply by Zoran Ivić - Friday, November 20, 2015 12:14 PM
-
0 Votes
SSIS script task not deleting files when running from sql server agent job
is there something I could add to log any errors or to try and find out what is happening. The system account running SQL Management Studio jobs is Sql Server Agent --> ...Proposed | 4 Replies | 41 Views | Created by aidan1972 - 22 hours 28 minutes ago | Last reply by aidan1972 - 8 minutes ago -
0 Votes
Currency symbol $ is not being loaded into Excel from SSIS 2008 R2 where as Source data have
Converting to VARCHAR and appending $ symbol (in SQL) -> Data conversion to DT_WSTR (in SSIS) -> Loading to Excel (in SSIS) When we follow this $ symbol is not present in ... -
0 Votes
Create a Project Connection that can be Used in Packages that Reside in a Different Project
I have a project "Main", which has a number of "Execute Package Tasks", which are set to a SQL Server External reference. These tasks run packages that are on "Integration ...Answered | 9 Replies | 52 Views | Created by DanHaf - 20 hours 12 minutes ago | Last reply by DanHaf - 24 minutes ago -
0 Votes
CR/LF and line positioning issue
Hello All- I’m having an issue with a CR/LF positioning and hoping someone can point out what I’m doing wrong here. I have a flat file that I’m creating via a sql ...Unanswered | 1 Replies | 27 Views | Created by cwilliams211 - 55 minutes ago | Last reply by Visakh16 - 41 minutes ago -
0 Votes
Importing from web sources - SSIS 2016-2017
Hi, I'd like to know if it is possible to connect to a web sources like Google Analytics and Facebook to import data. Any suggests to me, ...Unanswered | 2 Replies | 27 Views | Created by pscorca - 2 hours 24 minutes ago | Last reply by pscorca - 1 hour 51 minutes ago -
0 Votes
Export data from SAP BW to SQL via SSIS
I downloaded the Microsoft BW connector but I cant find SAP BW source under the Sources tab in SSIS. Am I missing some steps in between? Thanks!Unanswered | 2 Replies | 34 Views | Created by JGeorgeV - 20 hours 21 minutes ago | Last reply by Pirlo Zhang - 4 hours 47 minutes ago -
0 Votes
Error 0xC0010014 while preparing to load the package.
Hi, I get above error when executing a scheduled package,package runs successfully for about one week and then i receive this error. i checked package ...Unanswered | 6 Replies | 44 Views | Created by knewsql - 22 hours 33 minutes ago | Last reply by Pirlo Zhang - 4 hours 57 minutes ago -
0 Votes
SSIS Excel C# Import Script returns empty table when importing xlsx file saved by other users
I have created a SSIS import task, where in For Each Loop container I have Data Flow Task, in which I have Script Component where I try to import xlsx files from external drive ...Unanswered | 6 Replies | 66 Views | Created by northest - Wednesday, April 18, 2018 9:49 AM | Last reply by northest - 6 hours 31 minutes ago -
0 Votes
Excel File on SharePoint as a Data Source
Hello Experts, I am building an SSIS package that will load an excel file into a SQL Server table from sharepoint. This excel file is loaded to the sharepoint ...Unanswered | 2 Replies | 89 Views | Created by Nat85 - 15 hours 5 minutes ago | Last reply by Nat85 - 7 hours 6 minutes ago -
0 Votes
Excel Refresh doesn't work in SSIS 2017 by Using Script task
Hi, I am trying to refresh Excel file in SSIS 2017 using Script task, below is the script that I have written ...Unanswered | 3 Replies | 63 Views | Created by Nag2456 - Wednesday, April 18, 2018 11:14 AM | Last reply by Pirlo Zhang - 9 hours 10 minutes ago -
0 Votes
Do SSIS jobs that run in Azure need a special Visual Studio build?
Hi, We are going to need a bunch of batch SSIS jobs running in Azure to pull from Oracle and Teradata. I do c# programming and Azure builds have ...Unanswered | 2 Replies | 38 Views | Created by flash7gordon - 19 hours 28 minutes ago | Last reply by flash7gordon - 14 hours 57 minutes ago -
0 Votes
Excel to SQL via SSIS - sum of columns in SQL don't match but has greater value than the Excel extract
I have to extract excel files (data comes from SAP) into SQL using SSIS. In the file, there is 1 column - [TotalDue] which is the main total and 6 columns which are sub totals. After loading, I check ...Unanswered | 9 Replies | 79 Views | Created by JGeorgeV - Tuesday, April 17, 2018 2:00 PM | Last reply by ArthurZ - 19 hours 59 minutes ago -
0 Votes
Setting up connection between SAP BW and SSIS
Hi, Could anyone guide me in setting up connection between SAP BW and SSIS. We have SQL server running 2008 R2 running and SAP BW 7.3 version. what is the ...Answered | 5 Replies | 379 Views | Created by VIJSIV - Wednesday, April 05, 2017 2:33 PM | Last reply by JGeorgeV - 20 hours 27 minutes ago -
0 Votes
SSIS Pick up Excel file from folder
Hello I have to develop a SSIS package that will check a folder for a Excel file, if the file exist import the file in to SQL Server and Update data in my sales table with data from ...Answered | 8 Replies | 68 Views | Created by SQLSearcher99 - Tuesday, April 17, 2018 10:53 AM | Last reply by Pirlo Zhang - Wednesday, April 18, 2018 6:37 AM -
0 Votes
Issues Teradata OLE DB and SSIS 2010
Do you know what is the most recent Teradata OLEDB version supported in Microsoft Visual Studio - SSIS 2010? The reason is because everytime I try to configure my connection manager having ...Proposed | 2 Replies | 48 Views | Created by MartinSSIS - Tuesday, April 17, 2018 7:58 PM | Last reply by MartinSSIS - Wednesday, April 18, 2018 1:52 AM -
0 Votes
expression in SSIS
Hi, I have the variables expression from SSIS below " SET FMTONLY OFF declare ...Answered | 2 Replies | 53 Views | Created by Vicki2017 - Tuesday, April 17, 2018 4:33 PM | Last reply by Vicki2017 - Tuesday, April 17, 2018 5:09 PM -
0 Votes
Oracle and Teradata passwords in a central place for ssis?
Hi, Right now we are doing some of our ETL with c# and bulk insert. We are considering moving these processes to Azure Cloud SSIS but we have a ...Answered | 4 Replies | 67 Views | Created by flash7gordon - Monday, April 16, 2018 9:58 PM | Last reply by flash7gordon - Tuesday, April 17, 2018 4:45 PM -
1 Votes
Help - how to get column headers to flat file
Hi, I have a flat file destination but have no idea how to capture the column headers to the output file. Is ...Answered | 17 Replies | 6985 Views | Created by sadie2 - Tuesday, November 25, 2008 3:41 PM | Last reply by ThomasRones - Tuesday, April 17, 2018 2:50 PM -
0 Votes
Error at XML Source task
Hi, We are getting the following package when executing in production. The package is working fine in other environments. In what situation, XML source task will return - ...Unanswered | 1 Replies | 45 Views | Created by Pradeep Nulu - Tuesday, April 17, 2018 11:57 AM | Last reply by Visakh16 - Tuesday, April 17, 2018 12:14 PM -
0 Votes
SSIS Process Task Not Writing Log File
> operator. This works ok, when I run the file from the command prompt and the log file gets created, but as soon as I move this to the SSIS process task, everything works except writing ...Proposed | 6 Replies | 88 Views | Created by SaugatMukherjee - Monday, April 16, 2018 1:58 PM | Last reply by Pirlo Zhang - Tuesday, April 17, 2018 9:49 AM - Items 1 to 20 of 62396 Next ›
No announcements
