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 | 148338 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/DB Trigger to Update Server Groups & SharePoint Group from SQL Table
Hi, The OLAP Access is stored in a Group on the Server, can I via a SQL DB Trigger or SSIS pkg to store users values in a table and push/update to the the group on server and a ...Proposed | 2 Replies | 197 Views | Created by Ismailc1 - Tuesday, December 24, 2019 4:31 PM | Last reply by Ismailc1 - 12 hours 44 minutes ago -
0 Votes
SSIS Access a one drive location excel file
Hi, My sql account does not have access to a one drive location but I use my credential and I can navigate from the web how can I do this using a ssis package ...Proposed | 16 Replies | 1262 Views | Created by Ismailc1 - Friday, December 6, 2019 1:31 PM | Last reply by Ismailc1 - 13 hours 0 minutes ago -
1 Votes
SSIS to replace 15 batch jobs (written in C#) which load txt, csv, xml files into SQL Server database
Hello, We are a small company which receive ~50 files per day from different data sources which we load into a SQL Server database. We currently have this broken down ...Unanswered | 2 Replies | 84 Views | Created by DanC1972 - Friday, December 27, 2019 6:20 PM | Last reply by DanC1972 - Friday, December 27, 2019 11:00 PM -
0 Votes
Retain connection, avoid re-loading data in ForEach Loop Container while processing in-memory
I have been scratching my head over this design for quite some time now and I think it is time to ask for help. I have designed a SSIS package which uses a FELC to enumerate over an ... -
0 Votes
overriding conn string leads to anonymous log on
Hi we run 2017 std. At ...Answered | 11 Replies | 574 Views | Created by db042190 - Friday, December 20, 2019 3:39 PM | Last reply by db042190 - Friday, December 27, 2019 6:37 PM -
0 Votes
parse json response from rest api
Hi, I am using SSIS script task to parse json response from rest api. When I try to deserialize json payload using newtonsoft json the assembly reference does not stick if I were to close and ...Proposed | 3 Replies | 398 Views | Created by CSharp Enthusiast - Friday, December 20, 2019 6:20 AM | Last reply by COZYROC - Friday, December 27, 2019 3:08 PM -
0 Votes
Flat File Connection Manager "ConnectionString" Expression has mis-matched quotation marks
My Flat File Connection String is being satisfied within its Properties and the ConnectionString which is a formula within my SSIS Package. @[User::GlobalFilePath] + ...Proposed | 2 Replies | 117 Views | Created by ITBobbyP - Thursday, December 26, 2019 3:33 PM | Last reply by Mona Lv - Friday, December 27, 2019 4:15 AM -
1 Votes
Slowly changing dimension - ODS and DWH
I have the following dimension EmployeeStatus in my datawarehouse : SELECT des.EmployeeStatusSK ,des.EmployeeStatusId ...Unanswered | 2 Replies | 125 Views | Created by Test test tes - Thursday, December 26, 2019 10:54 AM | Last reply by Lily Lii - Friday, December 27, 2019 3:13 AM -
4 Votes
SSIS - Batch Size
Hello everyone, I have a doubt about the batch size issue. When I set a batch size of 500 at my destination, does this mean that the data from my source will be broken into blocks ...Answered | 8 Replies | 291 Views | Created by MasterZyon - Tuesday, December 24, 2019 5:28 PM | Last reply by MasterZyon - Thursday, December 26, 2019 12:13 PM -
0 Votes
SSIS Job just hangs when a connection lost in between runs
Hi, SSIS Job just hangs when a connection lost in between runs Is there a way to set expire limit on a job & package then stop job and disable then ...Answered | 13 Replies | 931 Views | Created by Ismailc1 - Wednesday, December 11, 2019 6:31 PM | Last reply by Ismailc1 - Thursday, December 26, 2019 10:18 AM -
1 Votes
How to add drop downs to excel exports
I am creating dynamic excel files with each file consisting of 2 worksheets in it. In both the worksheets I am looking to create a drop down with few values for few of my ...Proposed | 9 Replies | 1118 Views | Created by minhalraffat - Thursday, September 26, 2019 2:27 PM | Last reply by Mona Lv - Thursday, December 26, 2019 8:11 AM -
0 Votes
Setting "Set values" when defining a SQL Server Agent Job to Execute your SSIS Package
This got a little more complicated than I thought. I kind of thought the SSIS Package Variables specified in the SQL Server Agent Job Set and Set values would be satisfied at run time. It ...Unanswered | 3 Replies | 203 Views | Created by ITBobbyP - Tuesday, December 24, 2019 5:26 PM | Last reply by Lily Lii - Thursday, December 26, 2019 1:50 AM -
0 Votes
Flexible File Destination filename from variable
Hi All, I'm using Flexible File Destination to insert records to Data Lake Gen2 files, my question is how can i pass variable to the filename property? Everyday ...Unanswered | 5 Replies | 379 Views | Created by Mohamed Abd El-Ghaffar - Tuesday, December 17, 2019 10:31 AM | Last reply by Lily Lii - Wednesday, December 25, 2019 7:43 AM -
0 Votes
Flexible File Destination enable appending data mode
Hi All, I'm using Flexible File Destination to upload date to Azure Data Lake. i'm using For-each container to loop on dates and return data. But every-time flexible file ...Answered | 5 Replies | 185 Views | Created by Mohamed Abd El-Ghaffar - Tuesday, December 24, 2019 9:05 AM | Last reply by Mona Lv - Wednesday, December 25, 2019 5:55 AM -
11 Votes
SSIS Wizard cannot import text columns longer then 255 using Excel source
(Applies to SQLServer 2005 SP1) We have found that using the SSIS "Import and Export Wizard" using the "Microsoft Excel" data source that there appears to be a ...Discussion | 24 Replies | 71321 Views | Created by mcdrewski - Wednesday, November 29, 2006 2:05 AM | Last reply by dludwig - Wednesday, December 25, 2019 4:31 AM -
1 Votes
How to use parameter or variable to specify table name or query in SSIS OLE DB Source
MY GOAL: I want to use a data flow in a for loop container, where each iteration of the for loop sets the name of a database table in a string variable using an expression ...Answered | 1 Replies | 238 Views | Created by CSGuy101 - Tuesday, December 24, 2019 8:30 PM | Last reply by Mona Lv - Wednesday, December 25, 2019 3:03 AM -
1 Votes
Will adding a new column to a existing UTF -8 file at the end in SSIS package break the mapping ? SSIS 2014
Will adding a new column to a existing UTF -8 file at the end in SSIS package break the mapping ? Existing ...Answered | 6 Replies | 502 Views | Created by MLTC - Monday, December 23, 2019 7:09 PM | Last reply by Yitzhak Khabinsky - Tuesday, December 24, 2019 4:22 PM -
0 Votes
Scheduling SSIS Package via SQL Server Agent
I need the 4-1-1 on this..."Scheduling a SSIS Package via a SQL Server Agent Job 101" The UI is easy enough...I need the niddy griddy...Like what service account does it ...Proposed | 3 Replies | 231 Views | Created by ITBobbyP - Monday, December 23, 2019 10:39 PM | Last reply by Vaibhav-Chaudhari - Tuesday, December 24, 2019 5:10 AM -
0 Votes
SSIS Package is working fine in SSDT but givign error in SQL Agent JOB
I am getting below error using SSIS package created in SSDT 2019 and SQL server 2019 in SSMS v18.4. its working fine when i am running from SSDT and only giving ...Proposed | 2 Replies | 203 Views | Created by Bhavesh7098 - Monday, December 23, 2019 12:45 AM | Last reply by Mona Lv - Monday, December 23, 2019 9:53 AM -
0 Votes
Execute package in job agent delete all the records in the table
Hello everyone, I have a package to update a table in data warehouse. The updates include adding, updating, and deleting. When I run the package through Visual Studio and ...Unanswered | 13 Replies | 1000 Views | Created by XiaowenF - Thursday, December 12, 2019 2:06 PM | Last reply by Lily Lii - Monday, December 23, 2019 5:50 AM - Items 1 to 20 of 65376 Next ›
No announcements
