sql server manager import wizard to import .csv and culture error
Jun 1, 2017 · I am using the SQL Server Import Wizard to import a .csv file but I cant get it to work.
Can we create index on msdb database for backupset objects
Oct 24, 2013 · I am using sql server 2008 with sp3. I want to confirm whether we can create index on msdb database for backupset objects or not. what is the purpose of this ???
getting all tables containing a special column with specific data
Aug 1, 2013 · since days I try to create a script that gives me a list of tablename for all tables containing a specific column that contains specific data.
Timeout When Connecting From SSIS to Oracle
Sep 9, 2010 · The Network config between the two SQL Servers is identical; Firewalls are also configured correctly. Both Servers are using the same Switch. However when I attempt to …
Data Flow Task:Error: Excel Source failed the pre-execute phase …
May 2, 2016 · I am trying to import data from an Excel (.xlsx) file into SQL Server. Excel file size is pretty big (128MB). It works fine if run in debug mode in SSDT but starts failing when I am …
Deleting Packages from Integration Services Catalog in SSIS 2012 ...
Sep 29, 2013 · I have deployed few packages in SSIS 2012 and they are available in the Integration Services Catalog. I want to delete a package.But I don't find any option to delete or …
Step by Step Guide to convert MSSQL DB to MYSQL DB
Sep 10, 2011 · I mean do u want to do any manipulations on the source data (i.e. MSSQL) before transferrring/migrating it to the destination db (i.e. MySQL)? If not, then you can directly use …
ssis script component - social.msdn.microsoft.com
Feb 5, 2013 · I have a script task that worked FINE yesterday. Now when I run it, I get the following error: [myTask [64]] Error: System.NullReferenceException: Object reference not set …
SSIS Error : Unable to complete login process due to delay in …
Dec 28, 2018 · Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "Unable to complete login process due to delay in opening server connection".
SSIS Package takes a long time to run - social.msdn.microsoft.com
Jul 28, 2015 · I built my first SSIS package. It takes 25 minutes to run. It pulls 3500 rows from a view (15 columns), converts to Excel data types, then updates one column of values using an …