SQLServerCentral / Discuss Content Posted by David Bird / Article Discussions / Article Discussions by Author

SSIS 2008 working with ADO.NET destination

kirthireddig — Wed, 10 Feb 2010 03:50:52 GMT

Hi,I am trying to load data from falt file source to Sybase IQ 15.1 destination using SSIS 2008. I am using ADO.NET destination component with Sybase IQ ODBC data provider to connect to the Sybase IQ db. Though the package is able to load the data, performance of the package is extremely slow. Its just loading 150 rows per minute. I am executing the package through SQL Server Agent. There are no data transformations in the package. Can any one please tell me how can i improve the performance?Thanks in advance--keerthi

SQL Overview Part 1

David Bird — Sat, 05 Jan 2008 23:26:11 GMT

Comments posted to this topic are about the item [B]SQL Overview Part 1[/B]

ADO.NET destination working with SSIS 2008

anil.borru — Tue, 08 May 2012 04:03:41 GMT

DTEXEC command works from command prompt, does not work from xp_cmdshell

mikeebertsr — Mon, 07 May 2012 15:50:58 GMT

Hello. This is my first time asking a question here. I hope I give enough detail to explain the problem.I have a DTEXEC command that is built on the fly by a stored proc. Here it is:dtexec /F \\lislefs1\filearchives\HSBSSouth\Datawarehouse\SSIS\SSIS_HLX_Extract\SSIS_HLX_Extract.dtsx /CONFIGFILE c:\users\mebert\default.dtsconfig /SET "\package.Variables[User::Source].Properties[Value]";"\"SELECT top 9 line_text line_text FROM ##HLXElg_extract154""When I paste this command into a DOS command window and run it, it runs perfectly. When I try to run it from a query window, it fails with this error:Msg 170, Level 15, State 1, Line 1Line 1: Incorrect syntax near '/'.Msg 1038, Level 15, State 3, Line 1Cannot use empty object or column names. Use a single space if necessary.Msg 170, Level 15, State 1, Line 1Line 1: Incorrect syntax near ''.This happens when I run the dtexec directly from a query window and also when I run it from xp_cmdshell.I thought about putting the SSIS package into a SQL Server Agent job and calling the job instead. I'm pretty sure that would work, but I can't allow the proc to continue processing until the package finishes.Please let me know if you need any more info. Any help would be appreciated.ThanksMike

Sql server 2008 SSIS Package

Zahid Hasan — Wed, 30 Dec 2009 15:36:15 GMT

Hi There, i have an ssis package that was created using sql 2008 business intelligence dev studio. Its run fine when i run it manuall on my machine. But when i imported it on our test server and schedule job i get this error.MessageDescription: The binary code for the script is not found. Please open the script in the designer by clicking Edit Script button and make sure it builds successfully. End Error Error: 2009-12-30 16:05:39.62 Code: 0xC0024107 Source: Script Task Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_SUCCESS (0). Started: 4:05:39 PM Finished: 4:05:39 PM Elapsed: 0.313 seconds. The package executed successfully. The step succeeded.Does anyone seen this before and any idea how to go about to fix this?Thanks

SQL Overview V - Monitoring Long Running Jobs

David Bird — Tue, 23 Mar 2010 21:43:52 GMT

Comments posted to this topic are about the item [B]SQL Overview V - Monitoring Long Running Jobs[/B]

Shrink Log file for all Databases

David Bird — Mon, 24 Sep 2007 14:08:14 GMT

Comments posted to this topic are about the item [B]Shrink Log file for all Databases[/B]

SQL Overview SSIS Package III - Full Package

David Bird — Mon, 21 Jan 2008 23:40:35 GMT

Comments posted to this topic are about the item [B]SQL Overview SSIS Package III - Full Package[/B]

SQL Overview SSIS Package II - Retrieving SQL Error Log

David Bird — Sat, 12 Jan 2008 12:08:25 GMT

Comments posted to this topic are about the item [B]SQL Overview SSIS Package II - Retrieving SQL Error Log[/B]

SQL Overview VI - Monitoring Process Locks

David Bird — Tue, 30 Mar 2010 22:43:42 GMT

Comments posted to this topic are about the item [B]SQL Overview VI - Monitoring Process Locks[/B]

Problem Downloading SQL_Overview_Part2.zip

fuller.artful — Fri, 15 Jul 2011 03:47:40 GMT

David,I have been reading all three sections of your SSIS tutorial, and downloading the zip files. For some reason I cannot download Part2. It says "Problem redirecting..."Arthur

How to create users and groups in sql server 2005

naveenkumar83bsc — Fri, 04 Feb 2011 06:21:49 GMT

Hi,I am new to this technology. I have doubt in security concepts. My faculty told that security concepts are very important,He asked me to create users and groups in sql server 2005.Please explain step by step process under GUI based.

Free Tools for the SQL Server DBA

David Bird — Thu, 05 Apr 2007 14:23:00 GMT

Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/dbird/2959.asp

Morning Review not working on SQL 2008 Servers

Kim Killian-SiteDataView — Thu, 13 Jan 2011 11:01:58 GMT

Morning Review not working on SQL 2008 Servers.I've been using the "Morning Review" at every job I have since I discovered it. Love it and it's so useful. I am having an issue though getting it to work with SQL Server 2008. Is there something I need to tweek in the SSIS packages or on the 2008 servers to get it to work? I love it and really want to continue to use it as I migrate from 2000 and 2005 servers to 2008.

Morning Review not working on SQL 2008 Servers

Kim Killian-SiteDataView — Thu, 13 Jan 2011 11:18:53 GMT

Morning Review not working on SQL 2008 Servers.I've been using the Morning Review reports at every DBA job I take - they are so useful. I've been noticing that they are not working on sql server 2008. Is there something that I need to tweek on the ssis package or the 2008 servers that will allow these reports to run properly. As I migrate srevers from 2000/2005 to 2008, it would still be very useful to use these reports. Any help is apprecaited. I've enabled xp_cmdshell and ole on 2008, but still not getting the reports.

Calling SSIS from Stored Procedure

Mohan.deval — Wed, 05 Jan 2011 15:48:43 GMT

Hi,Our server has SQl 2008 & SQl 2005 Side by side installation. I am able to execute a SSIS Package that executes as a job & Within BIDS successfully. The issue is when I try to execute it from a Stored procedure [code="sql"] declare @cmd varchar(1000) Declare @FromDate varchar(20) Declare @ToDate varchar(20) select @cmd = 'dtexec /F "' + @ssispath + '"' select @cmd = @cmd + ' /SET \Package.Variables[User::FromDate].Properties[Value];"' + @FromDate + '"' select @cmd = @cmd + ' /SET \Package.Variables[User::ToDate].Properties[Value];"' + @ToDate + '"' EXEC sp_configure 'xp_cmdshell', '1' --- Enable Command Shell RECONFIGUREexec master..xp_cmdshell @cmdEXEC sp_configure 'xp_cmdshell', '0' --- Disable Command Shell RECONFIGURE[/code]I get the following error. Not sure how to target for SQl 2008 ( Microsoft (R) SQL Server Execute Package Utility Version 10 ? for 32-bit) that my package is looking for, I mean to say the wrong DTExec being executed ? How can I give correct dtexec.exe path in command Shell @Cmd ? Please help.[code="other"]outputMicrosoft (R) SQL Server Execute Package UtilityVersion 9.00.1399.06 for 32-bitCopyright (C) Microsoft Corp 1984-2005. All rights reserved.NULLStarted: 5:32:33 PMError: 2011-01-05 17:32:33.24 Code: 0xC001700A Source: Description: The version number in the package is not valid. The version number cannot be greater than current version number.End ErrorError: 2011-01-05 17:32:33.24 Code: 0xC0016020 Source: Description: Package migration from version 3 to version 2 failed with error 0xC001700A "The version number in the package is not valid. The version number cannot be greater than current version number.".End ErrorError: 2011-01-05 17:32:33.24 Code: 0xC0010018 Source: Description: Error loading value "<DTS:Property xmlns:DTS="www.microsoft.com/SqlServer/Dts" DTS:Name="PackageFormatVersion">3</DTS:Property>" from node "DTS:Property".End ErrorCould not load package "D:\SSIS Migrated packages\SetupUpTimeReport\SetupUpTimeReport\SetUpTimeReport.dtsx" because of error 0xC0010014.Description: The package failed to load due to error 0xC0010014 "One or more error occurred. There should be more specific errors preceding this one that explains the details of the errors. This message is used as a return value from functions that encounter errors.". This occurs when CPackage::LoadFromXML fails.Source: Started: 5:32:33 PMFinished: 5:32:33 PMElapsed: 0.11 secondsNULL[/code]

Free Tools for the SQL Server DBA Part 2

David Bird — Thu, 04 Dec 2008 00:55:07 GMT

Comments posted to this topic are about the item [B]Free Tools for the SQL Server DBA Part 2[/B]

maximum key length is 900 bytes

eliassal — Thu, 30 Sep 2010 07:55:30 GMT

Very nice article. I ran the tables script and got the following errorWarning! The maximum key length is 900 bytes. The index 'IX_Database_Info' has maximum length of 1288 bytes. For some combination of large values, the insert/update operation will fail.Would this has any impact on code, thanks

SQL 2008

eliassal — Thu, 30 Sep 2010 08:40:19 GMT

I know that 2008 provides some reporting and data collection stuff but if I asm not mistaken it comes with an overheadThanks in advance

SQL Overview IV - DBA's Morning Review

David Bird — Sat, 31 May 2008 17:05:16 GMT

Comments posted to this topic are about the item [B]SQL Overview IV - DBA's Morning Review[/B]

SQL Server DBA Fights a Demon

David Bird — Sun, 16 Mar 2008 22:10:17 GMT

Comments posted to this topic are about the item [B]SQL Server DBA Fights a Demon[/B]

Missing Scripts?

Jeff Olson-435047 — Thu, 01 Apr 2010 11:33:31 GMT

Delete

Free SQL Server Tools - Part 1

mjg257212 — Fri, 22 Jan 2010 05:43:41 GMT

Does anyone have a line to Part 1 of this article?mjg

TOAD is not free

Ramon Jimenez — Fri, 22 Jan 2010 04:27:49 GMT

I think you were right Toad for SQL Server is no longer free.Regards

SQL_Overview SSIS package for SQL 2008

yoak — Mon, 15 Jun 2009 07:17:12 GMT

Hi, I have been using the SQL_Overview SSIS package specifically SQL_OVERVIEW_Part3 containing SQL_Overview_Package.dtsx in SQL 2005 quite some time with no issues. I copied the package and Database over to my SQL server 2008 server, Ran the Visual Studio Conversion Wizard which ran the SSIS Package Upgrade Wizard, I try to migrate it to a SQL server 2008 server that claims to have completed successfully. However, when I open the package itself, it just hangs.Do you have a converted one for SQL 2008 that works well?thanks,YOak

Import *.Dat file in SQL database

yoothasak1 — Wed, 08 Apr 2009 01:10:25 GMT

[color=green]Dear all, Please help me,I have a Log.Dat file which is from ArcView software. Inside the Log.Dat file like XML code: [/color]How can I import the fields "Time", "type", "code", "target" ... etc in to SQL database?Please help.

SQLIO - simple system performance for SQL Server

Alan Spillert — Mon, 29 Dec 2008 08:36:28 GMT

Microsoft SQLIO Disk Subsystem Benchmark Tool http://www.microsoft.com/DOWNLOADS/details.aspx?familyid=9A8B005B-84E4-4F24-8D65-CB53442D9E19&displaylang=enhas been very useful in comparing different disk IO systems. I've seen values between 600 on my desktop PC and 8000 on a SAN, and SQL Server seems to perform in proportion to these benchmarks.Alan

Get Database Info failing

BigSam — Mon, 15 Sep 2008 09:10:32 GMT

Steps in the Collect Database Info are failing. For example the Update Data Used Size step fails. The temp table is not created either. I can create the table if I only execute that portion of the query, but the remainder isn't working. I would think that I should be passing some variables to these steps, but it isn't setup to pass anything.What am I missing here?Thanks,

Missing package

cloe — Tue, 22 Jan 2008 01:25:56 GMT

Where can I find the last (full) package ?

Compare the Data in Two Tables

David Bird — Tue, 09 Oct 2007 13:32:07 GMT

Comments posted to this topic are about the item [B]Compare the Data in Two Tables[/B]

The Challenge: Litespeed v TDPSQL

David Bird — Tue, 21 Feb 2006 14:58:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/dbird/thechallengelitespeedvtdpsql.asp