How to sent SQLMAIL in SQL Server 2005, through SSIS job, when my particular field is updated in database, can we sent SMS also through the SSIS script.
How to sent SQLMAIL in SQL Server 2005, through SSIS job, when my particular field is updated in database, can we sent SMS also through the SSIS script.
View Answer
| Jul 19 2008 6:06 AM GMT
| asked by
Deepanshu
SSIS, SQL Mail, SQL Server 2005
Assigning access to SQL Server Integration Services (SSIS) packages
How do we assign access for users to SQL Server Integration Services (SSIS) packages?
View Answer
| Jul 3 2008 6:19 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server, SSIS, User Access
Error messages in Business Intelligence Development Studio on SQL Server Integration Sevices
I am new to SQL Server Integration Services (SSIS). When I went into Business Intelligence Development Studio (BIDS) and tried to create a new project, I received this error message:"Could not load or assembly 'Microsoft.DataTransformationServices.Wizards' or one of its dependencies. The system...
Answer Question
| Jul 1 2008 3:35 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server, SSIS, Business Intelligence
Migrating data from Oracle 9i Database to SQL Server 2005
I would like to migrate the data from all used-defined tables in Oracle 9i Database to SQL Server 2005. I know of options like Linked Server, SSIS, SSMA for Oracle and BCP. Which amongst these is the best way to achieve data migration?
View Answer
| Jul 1 2008 3:29 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server 2005, Oracle 9i, Data migration
Problem with SSIS & AS400, Source is AS400, Dest is SQL2005
When I'm trying to retrieve data from AS400, I received the below error:The column status returned was: "Text was truncated or one or more characters had no match in the target code page.".How do I know which code page to use besides the default of 1252?
View Answer
| Jun 24 2008 11:44 PM GMT
| asked by
Thuybui
AS/400 errors, SQL 2005, SSIS
how to update a remote sql server2005 database on webserver with multiple similar local database on windows server 2003
Hello, I am developing an application which has several local windows server 2003. All the servers are having sql server 2005 database exactly similar structure but different datas. I want to keep a remote webserver server having a similar database updated online from all these local...
View Answer
| May 30 2008 4:56 AM GMT
| asked by
Sahaj
Update remote database, SSIS, SQL Server 2005
having problem with SSIS package
i have created the SSIS package from sql server Server management and its work fine but the problem I’m having, when I try to run it from SQL Server Management jobs.Every time when train it from Sql jobs it failed.Please advice on ….
View Answer
| Apr 30 2008 7:12 PM GMT
| asked by
Atif
SSIS Package, SSMS, SSIS
How to Modify SSIS packages created by Copy Database Wizard in SQL Server 2005
Hello,I recently read Jeremy Kadlec great article titled, "Step-by-Step Guide: Migrating to SQL Server 2005 with Copy Database Wizard" at http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1194265,00.html.Question for anyone: I used the wizard to copy 12 databases from ServerA to...
View Answer
| Apr 11 2008 3:56 PM GMT
| asked by
Pjunk
Copy Database Wizard, SSIS, SQL Server 2005
Download files from a sharepoint site using SSIS.
Hi, i want to download multiple files from a sharepoint site using SSIS Script task with VB script. I am unable to write script.
Answer Question
| Apr 10 2008 7:36 AM GMT
| asked by
ToWin
SSIS, VBScript, SharePoint
How to create an SSIS package for importing an Access table to SQL Server, running SPs and exporting data to Excel
I need to create a SQL Server Integration Services (SSIS) package for importing an MS Access table into SQL Server, then running some stored procedures on this database and finally exporting the result to Excel.I am comfortable in writing queries and working in Management Studio but I don’t know...
View Answer
| Apr 8 2008 11:30 PM GMT
| asked by
SQL Server Ask the Experts
SSIS, SQL Server integration/interoperability, Stored procedures
How do I import a file to a SQL Server table with dates before 1970?
I have a package created in SQL Server Integration Services (SSIS) to load data from three flat files to a table in SQL Server 2005. I use the loop to go through the folder. I need to make sure that I don’t insert rows where a date column includes a year before 1970 (the epoch). I'm really new to...
View Answer
| Mar 21 2008 9:12 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server 2005, SSIS
How do I integrate SQL Server Integration Services and Blaze Advisor?
I am a Microsoft Business Intelligence (BI) Developer and currently working on a Pharmaceutical BI project. The client wants to integrate his Blaze Advisor rule engine to SQL Server Integration Services (SSIS) so that he can change the rules in Blaze Advisor any time and see the effect of it on the...
View Answer
| Mar 21 2008 6:58 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server, Business Intelligence, SQL Server integration/interoperability
How can I structure this in SSIS?
Within SSIS, I need to do the following:1. Select the max(to_date) + 1 from a table in SQL Server.2. Pass this value to a view where clause statement; this view is an Oracle view that needs this date value so I can get the new data from Oracle and load it into this same table in Step 1.How can I...
View Answer
| Mar 17 2008 2:36 PM GMT
| asked by
SQL Server Ask the Experts
SSIS, SQL Server 2005
How SSIS works with cluster SQL and non cluster SSIS service?
According to microsoft, we can cluster SSIS service but it is NOT RECOMMENDED.http://msdn2.microsoft.com/en-us/library/ms345193.aspxNow this is the situation that I have where I need to understand how SSIS works?Enviornment: Active Active cluster enviornment for SQL server with SSIS server...
View Answer
| Mar 14 2008 12:10 AM GMT
| asked by
Munnu
SSIS, SQL Server 2005
Unable to execute the saved SSIS package.
I have two servers server1 and Server2 both has SQL Server 2005 installed.Server1 has Enterprise Evaluation Edition SP1and server2 has Workgroup Edition SP2.Since server2 has workgroup edition I cannot open the saved SSIS package in server2.So I connected from server1 created a DTS package and...
View Answer
| Mar 14 2008 7:31 AM GMT
| asked by
MNA
SSIS, SQL Server 2005, DTS
Microsoft SSAS with Cognos Front End
Is there anyone out there that is working or has worked with a Microsoft back-end (SQL SVR 2005, SSIS, SSAS) and a Cognos front end ? What is your experience with this ?
View Answer
| Jan 29 2008 11:44 AM GMT
| asked by
Sjors & Sjimmie
Cognos, SQL Server, SSIS
SSIS only 255 rows uploaded ?
Hi,I have a simple Data Flow with an Excel Source and an OLE DB Destination to upload data from an Excel file to an SQL table. The Excel file has 8155 rows. Once the package is finished running, the SQL table only shows 255 rows. The data access mode is Table or view - fast load.Any...
View Answer
| Jan 23 2008 7:53 PM GMT
| asked by
SbcOrc
SSIS, Microsoft Excel
