I have an SSIS package that is supposed to insert data from a flat-file into a database table. For the sake of this example, let’s say I am wanting to insert User records. The data records come from …
Tag: ssis
Conditional Data Validation In SSIS
I have a situation where table has two main columns DataFieldName & DataFieldValue along with some identifier such as OrderNumber. Now in DataFieldName there is value named as “OrderDate”…
SSIS package works in debug mode, but hangs at step 2 when launched from the SQL Server job
Have a bit of a strange question here. We had a job in SQL Server that was being suspended on step 2 of an SSIS package. However whern I run the SSIS package in DEBUG mode it works fine. However if I launch the job from SQL Server it hangs at step 2. Step 2 basically returns about 2 million
How to auto generate data types for a SQL table
I have many denormalize tables with 200+ columns. These tables are in SQL Server and they often, if not always, have varchar(100) or nvarchar(100) (string) data types. However, most columns are either ints, floats or other data types. It is not possible for me to go through every table & col and pick and choose data types. Due to many
SQL Server 2019 – archive remote DB daily with archive date in each table
I am very new to SQL and was hoping for some help. I have a database that is hosted remotely and I want to take a snapshot of all the views and archive them in a local 2019 database daily with an ‘archived’ date field in each of the local tables. So far I have managed to set up an
SSIS Script C# Script Task to Add current date to a file using a variable
Im have this script to add current year month to a file in a directory. It works perfect with the directory path, but I want to change the directory patch for a variable, because every month its going …
SSIS import an excel file with multiple header rows
Newbie doing SSIS import of csv and excel files. Things have been going well until I ran into an excel file with multiple header rows. The number of rows between the headers varies. I only need to …
SSIS sending source Oledb data to S3 Buckets in parquet File
My source is SQL Server and I am using SSIS to export data to S3 Buckets, but now my requirement is to send files as parquet File formate. Can you guys give some clues on how to achieve this? Thanks, Ven Answer For folks stumbling on this answer, Apache Parquet is a project that specifies a columnar file format employed
Error in SSIS Package – There is a data source column with no name
I have a straightforward SQL statement that I posted into a DataFlow Task and got this dreaded error. There is no stored procedure or temp tables involved. What am I missing? The SQL works fine in SSMS and returns appropriate results. The query is pretty simple and I have never seen this error in SSIS before. Answer no column name
SAS IOM Data Provider – Access Denied – SSIS connection [closed]
I’m looking for guidance into how to integrate with the SAS IOM Data Provider through SSIS. It works fine when using SAS software but when trying to connect using the SAS IOM Data Provider in SSIS I …