No announcements
-
51 VotesFAQ - 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 | 145842 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 SQL Agent job - Error: for each sub folder : The get enumerator method of the for each enumerator
Hi. I have a SSIS Package , which runs fine in Visual studio. The package uses a for each file loop and the variable points to a folder like ...Unanswered | 3 Replies | 55 Views | Created by Venkatzeus - 5 hours 38 minutes ago | Last reply by ArthurZ - 59 minutes ago -
0 Votes
could not retrieve the table information for the connection manager 'excel connection manager'
I am trying to Connect to a file as a data source and I have tried everything from changing my connection string, to downloading the 64 bit and the 32 bit drivers , and setting the run the ...Proposed | 4 Replies | 539 Views | Created by soldierfc - Tuesday, July 2, 2019 2:38 PM | Last reply by AA-Gibbs - 1 hour 1 minutes ago -
2 Votes
JSON
Hi, Does anyone have any experience of interfacing with a JSON API from SSIS. In my case the API is via a URL and i need to pull the data somehow. I suspect I ...Answered | 4 Replies | 9513 Views | Created by John Shiangoli - Friday, April 9, 2010 3:09 PM | Last reply by JS Limbani - 3 hours 35 minutes ago -
0 Votes
JSON source component
Any knowledge of an SSIS source pipeline component which reads the JSON, a data interchage format. JSON looks pretty tempting for heavy ...Proposed | 12 Replies | 14042 Views | Created by jaegd - Saturday, April 12, 2008 5:44 PM | Last reply by JS Limbani - 3 hours 41 minutes ago -
0 Votes
SSIS OLE DB Source splits "FOR JSON" results into multiple record sets
My goal is to load JSON documents from a JSON query in SQL into MongoDB. I've discovered that when I have more than 2000 characters in my JSON results, the OLE DB Source object in ...Proposed | 3 Replies | 361 Views | Created by Jen L2 - Monday, August 20, 2018 8:54 PM | Last reply by JS Limbani - 4 hours 58 minutes ago -
0 Votes
Flat file (CSV) source format
I have a SSIS package loading a lot of CSV file, which first line is the column head. Some file are ordered differently. However, package still try to load the file use predefined column order (it ...Answered | 2 Replies | 4933 Views | Created by nkw - Thursday, May 3, 2007 2:34 PM | Last reply by JS Limbani - 5 hours 3 minutes ago -
5 Votes
For each loop container is not picking up the .csv source file
Hi Everone, Good morning. My package is having .csv file as a source and I kept OLEDB destination to load it. Stored the .csv file in a shared ...Answered | 5 Replies | 717 Views | Created by Naveen_kumar - Thursday, July 2, 2015 7:45 AM | Last reply by JS Limbani - 5 hours 14 minutes ago -
0 Votes
XML Source Task in SSIS
I got a SSIS package from Production and Its having an XML Source Task. But When I double click on that task, I am getting an Error saying object reference not set to an ...Answered | 3 Replies | 1917 Views | Created by Rajesh S Hegde - Friday, August 31, 2012 7:50 AM | Last reply by JS Limbani - 5 hours 18 minutes ago -
0 Votes
XML source to SQL Server
My souce is XML. Target is SQL Server. A field which is varchar has both numbers and characters gives this error. [XML Source [1]] Error: SSIS Error Code ...Answered | 5 Replies | 4427 Views | Created by NSG12 - Wednesday, March 31, 2010 8:19 PM | Last reply by JS Limbani - 5 hours 21 minutes ago -
0 Votes
SSIS Script Task FireInformation Messages Missing After FireError
I am using a SSIS Script Task and FireInformation messages to log progress. This works fine if the task succeeds but the messages are missing when the task fails and I issue a FireError ...Unanswered | 5 Replies | 75 Views | Created by DrBobH - 21 hours 54 minutes ago | Last reply by Mona Lv - 6 hours 24 minutes ago -
0 Votes
How to Eliminate ssis variable expression Max length
I have one package that package have 4 variables. Each variable length is 4 thousand characters. All 4 variables concatenating in one ssis variable expression. ...Answered | 4 Replies | 4915 Views | Created by cmk1 - Tuesday, February 14, 2012 12:35 AM | Last reply by Shivendoo Kumar Dubey - 7 hours 52 minutes ago -
0 Votes
Excel Source stopped working in SSIS
Hi all, since few days Excel Source in SSIS stopped working due to the following message Could not retrieve the table information for the connection manager 'Excel Connection ...Answered | 10 Replies | 418 Views | Created by CarloDB - Wednesday, September 18, 2019 10:50 AM | Last reply by mamoel - 7 hours 57 minutes ago -
0 Votes
How to change SSIS package or database table column to accept text values loading from excel spreadsheet that have been formatted to number
I am loading data from excel spreadsheet to SQL table using SSIS package. Excel spreadsheet column formatted to data type "Number" but column consists only texts ("Y" or ...Unanswered | 1 Replies | 53 Views | Created by Saphire77 - 10 hours 10 minutes ago | Last reply by Zoe Gu - 8 hours 13 minutes ago -
0 Votes
SSIS Data Conversion
HI, I need to load string 20190110 into SQL db as datetime. what will be the best way to load and how to use data conversion using SSIS. or shall i just load as varchar in ...Answered | 2 Replies | 65 Views | Created by MR_Patel - 14 hours 19 minutes ago | Last reply by MR_Patel - 10 hours 13 minutes ago -
0 Votes
The metadata could not be determined because statement 'REVERT...
Greetings. I have a 2016 SSIS Package SQL Server Native Client 11.0 connection. When attempting to have an OLE DB Command use this guy it throws up the following message when clicking on the columns ...Unanswered | 5 Replies | 81 Views | Created by ChrisRDBA - 23 hours 6 minutes ago | Last reply by Mona Lv - 11 hours 30 minutes ago -
0 Votes
Using Data access mode: "Table of View"; I NO longer can access the Sheet Name; With an "Excel Source" or "OLE DB Source"
After many hours of trouble shooting I am still do not understand how this is not working when it has worked in the past and with many SSIS packages that I have in place. Using ...Proposed | 7 Replies | 179 Views | Created by Jdelafuente - Thursday, October 3, 2019 7:02 PM | Last reply by Zoe Gu - 12 hours 50 minutes ago -
1 Votes
order by ..PIVOT SQL Server
Hi I have a pivot like this Select ...Proposed | 6 Replies | 166 Views | Created by billybobsonic - Thursday, October 3, 2019 2:30 PM | Last reply by Sabrina Zhang - 13 hours 9 minutes ago -
4 Votes
SSIS The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered
Hi All, In my SSIS package am reading data from .xlsx file and loading it into a database table. Am using "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + ...Answered | 19 Replies | 85643 Views | Created by CoolDbGuy - Thursday, August 9, 2012 11:57 AM | Last reply by Shivendoo Kumar Dubey - 15 hours 20 minutes ago -
0 Votes
Visual Studio 2017 SSIS - ODataSource Connected but Unable to load collection
I created a ODataSource1 connection. The test connection succeeded. I created OData Source, selectd the ODataSource1, select Collection and got an message in the Collection box ...Answered | 6 Replies | 86 Views | Created by danyeungw - 22 hours 29 minutes ago | Last reply by danyeungw - 15 hours 45 minutes ago -
0 Votes
How to deploy SSIS package using SSDT 2017?
Hi, I have just completed a SSIS package (my first package). Now I am looking to deploy the package on the production server. So I am looking to convert the package to deployment ...Unanswered | 8 Replies | 205 Views | Created by minhalraffat - Friday, October 4, 2019 8:02 PM | Last reply by ArthurZ - 17 hours 35 minutes ago - Items 1 to 20 of 65026 Next ›
No announcements
