No announcements
-
42 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 | 105312 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
Changing Providers in Connection String Issues
I've got eight 2005 SSIS packages that were accessing SQL Server 2018 for bulk data and a SQL Server 2000 for some data also. Both connection strings use the ...Proposed | 8 Replies | 95 Views | Created by Mimosa Arts - Monday, March 02, 2015 3:22 PM | Last reply by Katherine Xiong - 1 hour 4 minutes ago -
0 Votes
How to get value from a parent tag in XML source?
Hi All, Can anyone please help me achieving the below requirement? I have an XML source in the ...Proposed | 3 Replies | 79 Views | Created by K_Srinivas - Monday, March 02, 2015 4:25 AM | Last reply by Katherine Xiong - 2 hours 13 minutes ago -
0 Votes
Custom SSIS component is not loading in toolbox
I created a custom ssis componet and placed the dll in Pipelinecomponents folder of sql server and also in GAC But still it is not showing in Toolbox.Please ...Unanswered | 5 Replies | 58 Views | Created by Mahesh Machina - 23 hours 47 minutes ago | Last reply by SSISJoost - 3 hours 26 minutes ago -
0 Votes
Running SSIS from dtexec
I have a project that extracts data from a sql 2008 r2 database and writes it to an excel (2007) file. When I run it in debug everything works fine but when I run it from a command line I get ...Proposed | 3 Replies | 99 Views | Created by TAD52 - Friday, February 27, 2015 7:10 PM | Last reply by Visakh16 - 5 hours 49 minutes ago -
1 Votes
store files in Array from directory using script task
How do we the store files from directory into array. I have below code but looks like something is wrong. Any help much appreciated. string[] sourceFiles ...Proposed | 3 Replies | 68 Views | Created by SQL Insane - Monday, March 02, 2015 8:17 PM | Last reply by ArthurZ - 9 hours 11 minutes ago -
0 Votes
formatting flat file in SSIS
I have an output table with CREATE TABLE [dbo].[Extract_wt_693_Truven_Intel_PharmacyClaims_Output]( [RowId] [int] IDENTITY(1,1) NOT NULL, [OutputRow] ...Unanswered | 1 Replies | 41 Views | Created by Dre01 - 9 hours 30 minutes ago | Last reply by Dre01 - 9 hours 28 minutes ago -
0 Votes
Can I access a variable from a dataflow task?
I have a dataflow task with an OLE DB Source which uses a SQL Command. I need to have the sql text access a variable that is at the package scope. Is there a way ...Unanswered | 4 Replies | 55 Views | Created by shiftbit - 12 hours 59 minutes ago | Last reply by shiftbit - 11 hours 33 minutes ago -
0 Votes
Task to add new row and values to Table?
Hi, I am new to SSIS, I have a table that I would like to capture daily currency conversion rates. In my Control Flow pane, I've been able to use a web service task to get a string value of ...Unanswered | 1 Replies | 51 Views | Created by marcus72 - 14 hours 38 minutes ago | Last reply by ArthurZ - 14 hours 28 minutes ago -
1 Votes
windows username change and encryption issue
My IT department decided to change my windows id based on the new standard they came up with and now i am getting the following error when i try to execute my SSIS package i am not sure how to ...Answered | 4 Replies | 46 Views | Created by Nikhil_NK - 17 hours 14 minutes ago | Last reply by Nikhil_NK - 14 hours 30 minutes ago -
0 Votes
Compare 2 Columns using SSIS from two different tables
Hello, A newbie to ssis. I have a Table 1 with Address Details and Table 2 with Address Details of same customer but from different sources. I have loaded these ...Unanswered | 1 Replies | 48 Views | Created by CrazySam81 - 14 hours 42 minutes ago | Last reply by ArthurZ - 14 hours 31 minutes ago -
0 Votes
Call child package x number of times from parent package
I have a child package that I need to call x (10 or less) number of times and have those all run at the same time. The parent package should kick them off either simultaneously or one after the other, ...Unanswered | 1 Replies | 52 Views | Created by tkizer - 15 hours 27 minutes ago | Last reply by ArthurZ - 15 hours 3 minutes ago -
0 Votes
A buffer failed while allocating bytes.
What is the Exact fix for the following error message in SSIS Error: A buffer failed while allocating 3640 bytes. Error: The system reports 89 percent ...Unanswered | 1 Replies | 42 Views | Created by Abhinav530 - 15 hours 57 minutes ago | Last reply by ArthurZ - 15 hours 28 minutes ago -
0 Votes
execute process task to append file
hi i am using execute process task to append one file (header) to main file. in expession i am using this "/c ...Answered | 5 Replies | 54 Views | Created by coool_sweet - 19 hours 22 minutes ago | Last reply by coool_sweet - 16 hours 32 minutes ago -
0 Votes
SQL Server BI Development Environment Setup
I am seeking recommendations on environment setup for SQL Server 2014 BI Development (small team) Currently we are a team of 2 persons doing some development on our ...Unanswered | 1 Replies | 39 Views | Created by dakine81 - 18 hours 8 minutes ago | Last reply by ArthurZ - 17 hours 33 minutes ago -
0 Votes
How to Run 2012 SSIS packages on 2008R2 Version
HI Friends, I have scheduled a job to run 2012 SSIs packages on 2008R2. I am getting this error can you please Give any ideas how can I run them without ...Unanswered | 2 Replies | 46 Views | Created by Cherukuri19 - 20 hours 57 minutes ago | Last reply by Beginner Bachi - 17 hours 34 minutes ago -
1 Votes
Change Charset of SSIS package from Unicode to Latin 1
I created an SSIS package which makes queries my DB and exports the Result to a CSV File, in order to import the data into the DB of another system B (which I don't have access to). According to the ...Unanswered | 9 Replies | 76 Views | Created by Ronin47 - Wednesday, March 04, 2015 10:42 AM | Last reply by Ronin47 - 17 hours 45 minutes ago -
1 Votes
Help -- How do I exit a Foreach Loop
I have a foreach loop that is processing files in a directory. One of the tasks is the execute sql task that calls a stored proc. If this stored proc returns a certain value then I need to ...Answered | 4 Replies | 7313 Views | Created by GN-Updated - Thursday, June 08, 2006 3:55 PM | Last reply by BI Admin (Bryant E. Byrd) - 18 hours 50 minutes ago -
2 Votes
What does SSIS VARCHAR Parameter Size = -1 do?
We have a number of SSIS packages at work where the Parameter Size defined in EXEC SQL Tasks and OLEDB Command Transformations is defined as -1 for VARCHAR parameters. They are ...Answered | 7 Replies | 158 Views | Created by Ron Ruble1 - Wednesday, February 25, 2015 4:41 PM | Last reply by Ron Ruble1 - 19 hours 17 minutes ago -
0 Votes
Link between sysssislog.executionid and job_id (in sysjobs, sysjobhistory)
Using: SQL Server 2014, SSDT-BI 2014 (VS 2013) Since last week I log my SSIS tasks in the sysssislog table. For each job that i execute, a new executionID (executionid column in ...Unanswered | 1 Replies | 37 Views | Created by T-o-b-i-a-s - 20 hours 2 minutes ago | Last reply by ArthurZ - 19 hours 53 minutes ago -
2 Votes
SSIS Package issue while OLEDB Connection String retrieved from variable.
Hi, My SSIS Package(VS2012) have two different SQLServer connection called SrcCon and DestCon . And its working fine with normal scenario. But when I try to pass the connection ...Unanswered | 4 Replies | 73 Views | Created by Vasantha Praba - Wednesday, March 04, 2015 9:38 AM | Last reply by Visakh16 - 22 hours 40 minutes ago - Items 1 to 20 of 54419 Next ›
No announcements
