No announcements
-
2 VotesWho will be announced as the next SQL Server Integration Services Guru? Read more about April 2019 competition!
What is TechNet Guru Competition? Each month the TechNet Wiki council organizes a contest of the best articles posted that month. ...
-
50 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 | 141841 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
Automate SSIS Project Deployment, Create environment , environment variables, environment reference and Map Project Parameters to environment variables
HI I am trying to automate all steps from deploying a ssis project to referencing an environment and mapping Project Parameters with environment ...Unanswered | 1 Replies | 42 Views | Created by Rajm0019 - 5 hours 47 minutes ago | Last reply by Yang.Z - 7 minutes ago -
0 Votes
error code 0xC0202009
Hi, I've a weird issue, i've a package on SSIS 2017, the source is SQL 2017 DB, the OLE DB source fails with that error when I run it locally or on the ...Unanswered | 1 Replies | 58 Views | Created by Jason Yousef - 8 hours 20 minutes ago | Last reply by Mona Lv - 25 minutes ago -
0 Votes
Table or View -fast load is failing on SQL Server 2012 but working on SQL Server 2016.
Hi I am facing this issue where I am not able to use the Table or View -fast load to load into a Oracle Staging table. The reason I am using the Fast Load is it is very very fast ...Unanswered | 1 Replies | 35 Views | Created by reddy421 - 7 hours 18 minutes ago | Last reply by Yang.Z - 1 hour 7 minutes ago -
0 Votes
For each loop editor - Filter files don't work fine.
Hi I have the filter.... But I see that the package find not only files such as *.xls. In addition, it finds files as: ...Unanswered | 1 Replies | 43 Views | Created by neonash - 9 hours 4 minutes ago | Last reply by Yang.Z - 1 hour 25 minutes ago -
0 Votes
Aggregation
Hi, (My question is at the end) SRC Table Description: Orders (orderId, OrderDate), OrderDetails (OrderId, Quantity, ...Unanswered | 1 Replies | 54 Views | Created by Octopus01 - 18 hours 12 minutes ago | Last reply by Mona Lv - 1 hour 36 minutes ago -
0 Votes
convert from varchar to decimal or numeric
hello , i have a problem dealing with convertion so i have a column that contain amount with type varchar ( because i extract it from an excal so i came with varchar ...Unanswered | 11 Replies | 163 Views | Created by AsmaGh - Wednesday, April 24, 2019 9:45 AM | Last reply by Yang.Z - 1 hour 48 minutes ago -
0 Votes
SSIS OLEDB - Receiving error ORA-01403 No Data Found when trying to load records into oracle GTT
I am trying to load records from one table, on a SQL Server, into a global temp table on a Oracle server. I'm able to load the records successfully if I set the dataflow task to a default ...Unanswered | 1 Replies | 52 Views | Created by Lozik - Thursday, April 25, 2019 3:49 AM | Last reply by Yang.Z - 2 hours 13 minutes ago -
0 Votes
Stored Procedure not giving correct result calling from SSIS
The below stored procedure is being called from SSIS Package. The result of stored procedure is stored in variable through resultset. now the problem is it is not showing 'Running' ...Unanswered | 6 Replies | 60 Views | Created by myGodsql - 11 hours 16 minutes ago | Last reply by André Renato Furtado - 2 hours 31 minutes ago -
13 Votes
The Script Task uses version 15.0 script that is not supported in this release of Integration Services
Hi All, We are migrating an SSIS project from SQL 2012 to SQL 2016. The project upgraded successfully without any issues and able to run few packages without any errors. But there ...Proposed | 28 Replies | 22427 Views | Created by Nagesh CL - Monday, August 21, 2017 7:49 PM | Last reply by a8_b1t_w_rr10r - 6 hours 18 minutes ago -
0 Votes
Call the same PKG with different Param Value to run simoultanously - Good idea/locks or Create copies of PKG
Good day, I have a PKG that generates xml files and uploads to FTP that loops for 5 facilities (1A,2A,3A,4A,5A) parameter values. As the loop runs ...Unanswered | 5 Replies | 77 Views | Created by Ismailc1 - 11 hours 34 minutes ago | Last reply by Guoxiong - 6 hours 46 minutes ago -
0 Votes
SSIS package failed after test connection success
, Test Connection succesfull, can preview the sample data, destination connection succesfull, but getting the following error on ...Answered | 6 Replies | 3185 Views | Created by SQLism - Monday, March 25, 2013 4:00 PM | Last reply by Rajkumar shiva - 8 hours 31 minutes ago -
0 Votes
How do I parameterize my query?
Hi, I’m using SSIS ScriptTask for file transferring purposes and inside of the code I have a little query that inserts data into database table. The ...Unanswered | 2 Replies | 50 Views | Created by Sanja Vojnovic - 8 hours 58 minutes ago | Last reply by Guoxiong - 8 hours 40 minutes ago -
0 Votes
the last row in the sampled data is incomplete the coulmn row delimeter may be missing or the text is incorrectly
In the exmple given for SSIS package building, the sample file SampleCurrencyData.txt is been used. In the MSDN, the data in the Flat File Connection manager shows 4 columns where as in my case, ...Answered | 2 Replies | 8033 Views | Created by sharma.amitk - Friday, May 7, 2010 1:24 PM | Last reply by tmdalvi - 13 hours 57 minutes ago -
0 Votes
Dataflowtask shows wrong entries from SAP - MBEW fields
Hello community, I am fetching different tables from SAP via ODBC and everything works fine. But when I am touching MBEW or MBEWH with the fields LBKUM or SALK3 I am getting just ...Unanswered | 2 Replies | 75 Views | Created by Mario Wolf - Wednesday, April 24, 2019 2:29 PM | Last reply by Mario Wolf - 18 hours 26 minutes ago -
0 Votes
Lookup cache mode
Hi, when adding a lookup there is an option to mark the cache mode. Available options are: Full cashe , Partial cashe or No cashe. I believe ...Proposed | 1 Replies | 56 Views | Created by Octopus01 - 20 hours 24 minutes ago | Last reply by Mona Lv - 19 hours 14 minutes ago -
0 Votes
Obtain data from a device using SSIS package
Hi All, I want to automate following task using an ETL package. Right now we manually connect to a device using ...Unanswered | 3 Replies | 1767 Views | Created by Igor Gelin - Thursday, April 18, 2019 2:58 PM | Last reply by Mona Lv - 19 hours 43 minutes ago -
0 Votes
SSIS package ran on 2010, fails on 2016 with Cannot open datafile. What am I missing?
I have a very simple Data Flow task that moves the results of a query to a *.csv file on a network drive. It ran fine on SSIS 2010, but not now on SSIS 2016. Note: I have another solution ...Unanswered | 3 Replies | 82 Views | Created by Mac_McCaskie - Wednesday, April 24, 2019 4:15 PM | Last reply by Mona Lv - 21 hours 40 minutes ago -
0 Votes
How to pass a variable value from a Script task (c#) to a variable in the package
Hello everybody, I would greatly appreciate your help. I am giving some interaction in a SSIS package. I have a C# code ...Proposed | 3 Replies | 79 Views | Created by GonFer - Wednesday, April 24, 2019 4:31 PM | Last reply by Mona Lv - Thursday, April 25, 2019 2:42 AM -
0 Votes
Sql server Agent job - All steps are starting at the same time even they are scheduled in sequence
Hi, I have a sql server agent job which has 3 steps. All are Transact-SQL script (T-SQL) type. On step 1, I have set that Go to next step on success and ...Unanswered | 1 Replies | 65 Views | Created by RanPr - Wednesday, April 24, 2019 8:01 PM | Last reply by Yang.Z - Thursday, April 25, 2019 1:59 AM -
0 Votes
Performance Improvement of In memory OLTP over disk based table while inserting data from oracle
Hi, I was checking the performance of insert timing into In-memory table against disk based table. here are the details Using SSIS I am pulling data from Oracle ...Proposed | 3 Replies | 113 Views | Created by CoolDbGuy - Wednesday, April 24, 2019 5:26 PM | Last reply by philfactor - Thursday, April 25, 2019 12:16 AM - Items 1 to 20 of 64280 Next ›
No announcements
