What are common file extensions for web programming languages?

What file extensions are used most commonly by different languages? Please don't put source file names (like .java) but rather extensions that would be present in a URL for rendered pages. Here is...

How do you get an SSIS package to only insert new records when copying data between servers

I am copying some user data from one SqlServer to another. Call them Alpha and Beta. The SSIS package runs on Beta and it gets the rows on Alpha that meet a certain condition. The package then...

Disabling SSIS Package Validation when Loading a Package in the VS Designer

I have a few SSIS packages that are deployed to a SQL 2005 Server and are subsequently designed and maintained in Visual Studio 2003. When I open any of the BIDS projects, followed by one of the...

Update Rows in SSIS OLEDB Destination

I have a data flow process where I have an OLEDB Source and an OLEDB Destination like below: Source merges data from two staging tables and returns a result set (say, 50K rows). These 50K rows...

Using Connection manager in script task in ssis 2008

I have made ssis package where in I have taken Script task and by using that script task I am taking count from one of the Database table and sending that count in mail. Now,in that script task,if...

SSIS no column information was returned by the sql command

I ran my Stored Procedure in BI_Test_Server. Then I executed it using exec [dbo].[bi_resource_dimension_sp] 1,1 I got the results in SQL Server management Studio successfully. So I created a...

Assign values to ssis variable

I am trying to assgin a value to a variable in script component using C# but unable to do so. Can anyone please post the code or tell me what wrong below. public override void PostExecute() ...

Truncation Error when Importing Data SQL Server 2008

I'm trying to import data into SQL Server using the 'Import Wizard" and it fails with the error pasted below. I have tried 'Suggest Types' and manually set types to varchar 255. I've also set the...

Could not load file or assembly 'Microsoft.SqlServer.ManagedDTS, Version=12.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'

I have created as SSSIS package in BIDS 2013 and deployed code on server with following configuration: Window Server: 2012 SQL Server: 2014 SSIS is working fine. but when I change Server...

Excel in SSIS: How to import a column that may have more than 255 characters when DT_NTEXT causes failures?

OK, so my latest project requires loading an Excel 2007 spreadsheet into a SQL Server table. I'm working in SSIS 2008R2. Based on some stuff I found on the internet, I opened the Excel source in...

Delete empty node in XML file using SQL

Hi i have created XML file using XML Auto in SQL. The file is created based on the records from six tables. If there is no value in associated table, an empty node is created. Is there a way to...

Export All Views to Text Files

There are a number of views in a database on one of our servers. I need to save all the view definitions as text files in the following format: IF OBJECT_ID('<[Schema_Name].[VIEW_NAME]>') IS NOT...

SSIS loading data error

I have a CSV file which contains this...

Count number of files on FTP server

How do I count number of zip files present in an FTP folder in SSIS? Guide me to find the number of files present.

Query to get last 3 month's data in SSIS SQL Command

Hi I am developing an SSIS package in VS2008 for SQL Server 2008. To read the data from source, I have added the ADO.NET source editor and written below queries in the SQL command window but...

Failed to acquire connection. Connection may not be configured correctly or you may not have the right permissions on this connection

I am getting following error while attempting to execute the package. I can execute individual task successfully. But whenever attempt to execute whole package it gives me error. SSIS Data flow...

working days between two dates in ssis

I need help to calculate working days between 2 dates in ssis. Source is excel and destination is oracle. Sample date :I have 2 date fields from excel source some times date1 will greater than...

SSIS Foreach ADLS File Enumerator

I have a work with azure etc, I build a job in ssis that contains a for each for ADLS (Azure data lake store), it produces the path for some files. i make a data flow task inside the for each and...

Why do I get the error: "cannot communicate with the debug host process" when attempting to execute an SSIS package?

I create a new package in SSIS and when I try to run the package, SSIS returns the following error (displayed in a Visual Studio Error Dialog): "Cannot communicate with the debug host process. ...

SSIS - Source Assistant is not showing the Project Level Connections

I have created an OLE DB connection to project level (Native OLE DB\SQL Server Native Client 11.0). When I try to use it from the Source Assistant, I can not see it on the list. However, If I...

SSIS with large amount of data slow and bad Performance via Kingswaysoft

We have lots of SSIS packages that updates/creates records in a CRM. Some entities like contact, account, customer product (our custom entity to hold all account types) , while we are migrating...

SSIS Incremental Load-15 mins

I have 2 tables. The source table being from a linked server and destination table being from the other server. I want my data load to happen in the following manner: Everyday at night I have...

SQL Server Agent Job stops SSIS Step with "unexpected error" and without any error informations

I am dealing with my problem on some Windows Server 2019 (Core) with one running SQL Server 2019 CU4 instance each. What we try to do We are currently building a data warehouse with distributed...

Excel Connection Manager Failed to Connect via SSIS VS19

New to the SSIS world and I got it working before on Excel Version 2016 & Version 2007-2010 [after ages of troubleshooting] but then it just stopped working [endless testing on various solutions...

Could not load file or assembly SSIS Script Task

I have a DTSx with a Script Task that will replace some labels in a Word Document and then save it as PDF but it constantly shows error : "Could not load file or assembly '' or one of its...

BCP - Export Query to Tab Delimited Text File

I am using SSMS and trying to export a query to a text file using T-SQL (I know there are options in the tool itself to do this, but I need this code for a stored procedure). I found examples but...

SSIS - Extract from XML dtsx Package every SQLCommand / TableorViewName From Data flow task

Basically, my purpose is urbanization context is to retrieve ALL input Datasource (sqlcommand or tableorviewname) and ALL output datasources I did a first try succesfully with one of our dtsx...

How to using STRING_SPLIT within an SSIS OLE DB Source SQL Command when the database compatibility level is set to is set to SQL Server 2008?

I have an SSIS package on server 1. It does a SQL query on SQL db located on server 2 via the OLEDB source sql command text. The query is: SELECT * FROM PRODUCTS WHERE PRODUCT_NAME IN (?) This...

SSIS error message: Violation of PRIMARY KEY constraint

For a university group project, we are building a data warehouse using SQL Server Management and Visual Studio. We are currently in the staging area and want to fill the tables with data. It works...

Import multiple flat files in the same folder to SQL Server using flat file name as table name

I have been searching for an efficient way of uploading 100's of text files in the same folder to an SQL Server with one click of a button. I perform this every month, manually mapping the tables....