|
|
Browse by Tags
- 2005
- access
- activex
- BIDS
- C#
- cannot
- code
- column
- component
- Configuration
- connect
- connection
- create
- CSV
- data
- date
- debug
- derived
- dt_dbtimestamp
- dt_r8
- dt_text
- DTC
- Dtexec
- dts
- dtsConfig
- dtsx
- dynamically
- Dynamics SL
- each
- edit
- error
- error handling
- ETL
- EvaluateAsExpression
- excel
- Excel connection manager
- excel File
- execute
- execute process task
- expression
- failed
- file
- filter
- firewall
- flat
- Flat File
- flatfile
- FlatFile Insert or Update in SSIS
- flow
- For Loop Container
- foreach
- from
- ftp
- guid
- how
- How do I identify similar registries in a Database and Catalog them automatically?
- IBM and Microsoft
- IE 7.0
- import
- insert
- Lookup
- loop
- manager
- Microsoft
- MS Sql Server
- odbc
- Oracle
- package
- parameter
- pass
- procedure
- result
- script
- server
- source
- sql
- SQL 2005
- SQL 2008
- SQL Server
- Sql server 2005
- sql server 2008/2005
- SQL Server BI development studio
- SQL Server Integration Services
- SQLServer
- SSIS Lookup Task - Table from Variable Name
- stored
- string
- system
- Tablename Variable
- task
- t-sql
- type
- UPDATE
- using
- variable
- VB.NET
- vbscript
- Visual Studio
- Visual Studio 2005
-
How do I identify similar registries in a Database and Catalog them automatically?
Hi, I have a huge table with a lot of registries in a column wich I wish to catalog. The column looks in some way like this: Store -------- Apple Store MI Apple Store CA Online AppleStore WalMart NY WalMart WA Wal-Mart Optic Dept ...... ... I'm a total newbie in ETL's and just downloaded SQL... -
Split flat file into 2 excel files SSIS
I need to split a flat file into two excel files. No conditions except maybe if more than 40,000 rows then split. Otherwise just need two files. -
Poll a directory for variable filename
hi, I have a directory, in which a file will be dropped which needs to be imported into a table (sql 2008). I have a package working where it reads the file, and imports it into a table. What I would like to do is poll the directory, say every 10 minutes, and if a file is there, to process it. Once it's... -
SSIS output column (nullable)
Hi, Experts, I have problem for null value in SSIS "output column". in SQL server 2008 in my package, the input string is from excel sheet. and the strings are "either" empty or "has value" in the case of empty, I would like to put null in the database (SQL server 2008)... -
SSIS Lookup Task - Table from Variable Name
I can't decide if this is possible in SSIS or not. In a ForEach loop I am looping a number of tables in SSIS. Each table has a history table associated with it. I am using a lookup to check the history table for dupes. If the record exists it goes to a fallout table for investigation, if it doesn't... -
SSIS Lookup Task - Table from Variable Name
I can't decide if this is possible in SSIS or not. In a ForEach loop I am looping a number of tables in SSIS. Each table has a history table associated with it. I am using a lookup to check the history table for dupes. If the record exists it goes to a fallout table for investigation, if it doesn't... -
SSIS Lookup Task - Table from Variable Name
I can't decide if this is possible in SSIS or not. In a ForEach loop I am looping a number of tables in SSIS. Each table has a history table associated with it. I am using a lookup to check the history table for dupes. If the record exists it goes to a fallout table for investigation, if it doesn't... -
package validation error
i have a SSIS project (vs2005,MSSQLSERVER 2005) which has been working without problem . Now i am getting "failure inserting into read-only column" when i debug. I am transferring data from As400-iDB2 to MSSQLSERVER. When i open project first it asks the password for As400 login; then i start... -
SSIS updating tables
I have an excel spreadsheet that needs to be used to update some tables in a SQL Sever DB. The spreadsheet has similar columns for the most part but has a few extras that we need to append to the tables. So I basically need the tables to now look like the spreadsheet. Problem is there is a lot of data... -
TFS: Specify Projection Location in VS 2008
In Visual Studio 2008, when I right-click on the SQL Server Integration Services solution that I've created and choose "Add Solution to Source Control" it keeps putting it in a Team Project on Team Foundation Server that I don't want it in. No dialog box appears when I add it to source...