|
|
|
June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Filter by week: 1 2 3 4 5 Connecting via ODBC Posted by Kayda at 1/28/2007 4:40:23 AM Hi:
I'm finding with SSIS 2005 that the most basic functionality--being
able to connect to datasources--is very difficult. I've tried to
connect to Sybase via ODBC and OLEDB and had different problems each
way. As a test I tried an ODBC connection to Access and it also had
problems. I've ...more >>
SSIS and VBA Posted by MIB at 1/28/2007 3:47:01 AM Hi,
I have to create many formula on Excel spreadsheet. In now SSIS, and VBA
Excel but nothing else (i mean script or VB.NET). How can i use VBA in SSIS?
Thanks...more >>
Data Types Variable, Parameters and Sprocs Posted by Kayda at 1/28/2007 12:12:22 AM Hi:
I am having a lot more problems with data types in SSIS 2005 than in
DTS.
I have a global variable in an SSIS package which has a datatype, an
Execture SQL task which has a datatype, and a sproc which has a
datatype. The global variable is fixed and is just going to hold a
number o...more >>
Script Task Design Script Causes an Cannot Show Editor Error Posted by GrandeApps at 1/27/2007 9:46:00 AM I can place the Script Task component on the control flow tab. I then
double-click on the Script Task and it brings up the Script Task Editor. I
select "Script" on the left. So far, no problems. However, as soon as I
press the "Design Script" button, I get the following error:
=========...more >>
Looping through tables Posted by Kayda at 1/27/2007 1:03:22 AM Hi:
I need to move data from 15 tables from Server A to SQL Server 2005
database C, and then move data from 15 tables from Server B to SQL
Server 2005 database C. (For the record, Servers A and B are different
database products). The 15 tables on server A and server B are exactly
the same st...more >>
AS/400 Export/Import SQL Server 2000 Posted by Armand at 1/26/2007 2:47:00 PM Good afternoon, How Can I import data from a AS/400 server?, Thanks a lot ...more >>
Package execution failed. Decryption problem Posted by Benjamin Janecke at 1/26/2007 8:45:03 AM Hi,
I've got a problem with my maintaince plans after moving the entire database
(including system databases) to a new server.
Every package fails with the following error message:
Executed as user: FINANCEDB2\SYSTEM. The package could not be loaded. The
step failed.
When running a ...more >>
nightly refresh of a backup table - is it DTS Posted by info NO[at]SPAM sites4agents.com at 1/26/2007 7:39:16 AM Hi
I have a table
and its backup table in the same database
all I want is nightly:
truncate backup table
copy main table into the backup table
Is it DTS?
how to do it (without becoming an expert in DTS/dba)
Thanks
GSL
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SQL 2005: How do I access saved SSIS packages Posted by Conan Kelly at 1/25/2007 5:08:59 PM Hello all,
When I go through the Import/Export Wizard and select the option to save the
SSIS to SQL Server package near the end of the process, how do I access that
saved package to edit and run it?
In EM in SQL Server 2000, I could see the saved DTS packages by going to
Console Root>MS ...more >>
Why SQL jobs keep losing thier job history Posted by Mike Torry at 1/25/2007 1:57:01 PM My SQL jobs used keep their history on SQL Server 2000 MSDB. Recently all
jobs keep losing their job history. Each job only keep some history for very
short period.
Do you know why?
Thanks,
...more >>
Dynamic Properties Task Posted by Webtechie at 1/25/2007 1:45:00 PM Hello,
I've created a DTS package that works off a ini file on a server. The
server is a development server. Now I need to move it to QA. I save the
file for the QA folks. I've got an ActiveX script that takes the values out
of the ini file and creates the global variables to run the re...more >>
Variable - Capture Running Count of Errors Posted by Nathan at 1/25/2007 10:32:29 AM Hello,
I'm wondering if anyone knows an easy way to create a variable in SSIS
2005 that captures a running count of the errors occured on a given run
of a package. So far, I've tried setting up "SSIS log provider for SQL
Server", then creating an Execute SQL Task:
Input Parameter: System::...more >>
DTS Package Execute Crashes out of Enterprise Manager Posted by freeman642 NO[at]SPAM gmail.com at 1/25/2007 8:47:12 AM Help really needed, I am and have successfully imported data from the
Sage Accounts package into SQL Server 2000 to query. I am trying to
import a slightly larger piece of data into another table on the
database when its gets so far and then Enterprise Manager completely
closes with no warning o...more >>
DTS Question - Transform Data Task Posted by Paul at 1/25/2007 6:35:04 AM I am trying to write my first DTS in SQL Server 2000.
It is a very simple DTS. All it does is execute a query from a table in SQL
Server A and copy the results (transform data task) to a table in SQL Server
B. I am sure the query is good because I tested it.
So, using DTS Designer, I use S...more >>
reporting services on flat files... Posted by Dan Bass at 1/24/2007 4:24:29 PM Hey guys
Scenario
---------
I'm basically pulling a load of old data periodically from a bunch of client
MSDE machines onto a server, and pushing the data into flat files using a
..Net application that I knocked up. The flat files are delimited, and there
are multiple files based on their...more >>
SSIS Dataflow Script component Posted by pomarina at 1/24/2007 7:28:59 AM Hi,
In my control flow I am returning a result set from the sql db
containing some words. When I process incoming files I need to reject
rows if email column matches (not an exact match) any of these words.
I hoped I can create a script to loop each row through the recordset I
got in the con...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |