Stack Overflow
Stack Overflow

Questions tagged [ssis-2012]

Microsoft SQL Server Integration Services (SSIS) is a platform for building enterprise-level data integration and data transformations solutions. SSIS 2012 is a part of SQL Server 2012 Data Tools

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks.

SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data. wikipedia

1375 questions
3
votes
2 answers

SSIS - Data Conversion from DT_STR to int

How to apply the below transformation in SSIS data flow task cast(gift_amount as int)/100 In Derived Column Transformation Editor, I am unable to change the data type. It gives 0xC0049064 error upon giving typecast function.
Tom J Muthirenthi
  • 3,028
  • 7
  • 40
  • 60
3
votes
5 answers

The operation cannot be started by an account that uses SQL Server Authentication error When running ssis from stored proc in SSRS

I am getting the following error: The operation cannot be started by an account that uses SQL Server Authentication. Start the operation with an account that uses Windows Authentication I have a ssrs report which uses a dataset derived from a stored…
Julius Alexander
  • 431
  • 2
  • 6
  • 13
3
votes
2 answers

ssis assign a value to a guid when null

I have the following expression in ssis (ISNULL [rowguid]? (DT_WSTR, 255)"00000000-0000-0000-0000-000000000000":[rowguid]) What I want is to assign that guid if there is null present. I just can't seem to get it working
abs786123
  • 581
  • 2
  • 11
  • 24
3
votes
1 answer

How to reset object variable from script task in SSIS?

I am quiet a bit new in SSIS package writing and I have nested loop in my SSIS Package, one is looping for all the folders into a location and inner loop is looping through all the files in each folder. In folder level loop my first task is script…
Naim Halai
  • 355
  • 1
  • 8
  • 27
3
votes
0 answers

SSIS 2012: Packages runs in SQL agent, not in BIDS or cmd-line

I have a development server that will run packages from SQL Agent (according to schedule, and manually via Job Activity Monitor), but not by running it from BIDS or by two different ways on the command-line. The error we get in BIDS is:…
Kiwi Nick
  • 150
  • 1
  • 10
3
votes
1 answer

How to read all files of a folder based on their creation date in SSIS?

I've a folder and each day a few flat files get copied into it. The files have the same format and same structure. However, I want to read them into my database based on their creation order. Example: the file that was created at 1 pm must get…
TheEsnSiavashi
  • 1,245
  • 1
  • 14
  • 29
3
votes
3 answers

How to retain null values in flat file destination in ssis package

I have created an ssis package. in dataflow task, i am passing data from oledbsource to flat file destination. i want to retain null values in flat file but it is coming blank.
Asin
  • 63
  • 1
  • 9
3
votes
2 answers

How do I fix it when the SSIS designer pane goes white?

I've had a long-standing problem that every so often, when I open an SSIS package (2012), the designer pane is blank (all white). If I try to view the code, it comes up, but the file name in the tab shows up as blank. If I try to execute it, I get…
Quicksilver
  • 295
  • 4
  • 16
3
votes
2 answers

SSIS 2014 Project Deployment vs Package Deployment

We are in the process of upgrading our SQL server from 2008 to 2014 and separating the Database server from the file server. I changed my SSIS packages to have project parameters defined, which means that... when I deploy my project all 35 packages…
SDb
  • 63
  • 2
  • 7
3
votes
1 answer

Load An Xml File to OLEDB Destination using BIML -SSIS

I am trying to load an XML File to a database table, XML has the nodes as (EmpID, Name, Address1 and Address2) , I wanted to load this into Two tables Employee(EmpID,Name) and EmployeeAddress(EmplD,Address1,Address2) Problem I'm Facing: When i'm…
Arun Kumar
  • 337
  • 3
  • 7
  • 20
3
votes
1 answer

C# doing a convert timezone on thousands of rows. Randomly got "The supplied DateTime represents an invalid time."

Just a quick question as I am baffled. I have some code that loops through datarows in a ssis package to convert timezones and it is failing on a row and I have no idea why. The full error message is: The supplied DateTime represents an invalid…
user3494110
  • 417
  • 2
  • 9
  • 25
3
votes
1 answer

SSIS 2012 Error-Unable to connect to Integration Services

I am facing the below Error when connecting to Integration Services from SSMS.I don't have SSIS 2005 installed,don't know what this error message is. Please Help. Connecting to the Integration Services service on the computer "localhost" failed with…
Rosebud
  • 138
  • 1
  • 11
3
votes
1 answer

Integration services project Templates missing in VS 2015

I am trying to create Integration services project in VS 2015. i Installed the SQL Server Data Tools for VS 2015. i also installed SQL Server 2016. I still dont see the templates. can anyone please help.
Surya Garimella
  • 317
  • 4
  • 13
3
votes
1 answer

unicode flat file can't find CRLF row delimiter

I have a csv file that contains unicode characters (specifically Hindi characters) that I need to import using SSIS. When I set the connection to unicode, SSIS cannot find the CRLF delimiters. If I uncheck the unicode check box, it finds the CRLF…
JHFB
  • 441
  • 1
  • 5
  • 20
3
votes
1 answer

SSIS 2012 column header is too long for column width Extracting fixed width flat file

I am attempting to extract a table from sql database into a fixed width flat file. The file should have a column header I am attempting to recreate a file that already existed where the header for certain columns(for example Gender with a width…
Sean
  • 55
  • 4
1 2 3
…
91 92