|
More site info...
microsoft.public.sqlserver.integrationsvcs | Forum profile
|
|
Forum profile page for microsoft.public.sqlserver.integrationsvcs on http://www.microsoft.com/communities/newsgroups....
This report page is the aggregated overview from a single forum: microsoft.public.sqlserver.integrationsvcs, located on the Message Board at http://www.microsoft.com/communities/newsgroups....
This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional forum profile information for "microsoft.public.sqlserver.integrationsvcs" on the Message Board at http://www.microsoft.com/communities/newsgroups... is also shown in the following ways:
1) Latest Active Threads
2) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a forum's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity on microsoft.public.sqlserver.integrationsvcs:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
3
|
29
|
131
|
|
Post:
|
5
|
47
|
194
|
|
|
microsoft.public.sqlserver.integrationsvcs Posting activity graph:
|
Top authors during last week:
tg112001 via SQLMonster.com
2
user's latest post:
SSIS passing date variable to...
Published (2009-01-07 19:09:00)
Hi, I'm fairly new to SSIS and need some help on passing date variables. I'm pulling data from an Oracle db to our SS environment and have created 2 variables named: START (value = 21-DEC-2008) END (value = 28-DEC-2008) How do I pass these variables to this statement: SELECT Column1, Column2, Transaction_Date FROM Table A WHERE Transaction_Date BETWEEN START AND END I think I just need help with the proper syntax. thanks....
user's latest post:
Deleting SSIS 2005 projects in...
Published (2009-01-06 11:13:00)
Slick! Thanks. "Todd C" wrote: > If the Project is part of a Solution, then remove it from the Solution first. > Then simply delete it using an explorer window. > > To remove it from the Recent Projects list, click on it like you want to > open it and if it cannot be found, you will be asked if you want to remove it > from the list. Simple. > > HTH >...
user's latest post:
Deleting SSIS 2005 projects in...
Published (2009-01-06 10:47:00)
If the Project is part of a Solution, then remove it from the Solution first. Then simply delete it using an explorer window. To remove it from the Recent Projects list, click on it like you want to open it and if it cannot be found, you will be asked if you want to remove it from the list. Simple. HTH -- Todd C [If this response was helpful, please indicate by clicking the appropriate answer at the bottom] "Mike"...
|
|
|
|
Latest active threads on microsoft.public.sqlserver.integrationsvcs::
Started 1 day, 8 hours ago (2009-01-07 19:09:00)
by tg112001 via SQLMonster.com
Hi, I'm fairly new to SSIS and need some help on passing date variables. I'm pulling data from an Oracle db to our SS environment and have created 2 variables named: START (value = 21-DEC-2008) END (value = 28-DEC-2008) How do I pass these variables to this statement: SELECT Column1, Column2,...
Started 2 days, 19 hours ago (2009-01-06 07:44:00)
by Mike
How do you delete SSIS projects from Visual Studio / BIDS, including getting rid of them in the 'Recent Projects' area of the Start Page? Thanks, Mike
Started 3 days, 8 hours ago (2009-01-05 18:54:00)
by tg112001 via SQLMonster.com
SQL Server 2005 SP3 & Excel 2003 -------------------------------------------------- ---------------------------- -------- I have a package that exports data to an excel template. What I'd like to do is format the excel file after the sheet is dropped and reloaded. Can someone point me to sample VBS where I can connect to the ...
Started 2 weeks, 2 days ago (2008-12-23 07:14:00)
by Steven
I have a relatively simple package that watches for a file (File Watch Task) and then copies it to another location when the file appears in the folder (File System Task). That's it. I set it up as a job to run every minute, but once the file appears and gets copied, it would be up to another minute before it would be run again. I ...
Started 2 weeks, 3 days ago (2008-12-22 17:16:00)
by kbutterly
Hello all, I have to do a large dataload of about 10 tables. I have created a table two columns: the source table name and the destination table name. I have used a data task to get the rows of the table into a record set, which I am looping over. In my loop, I have created a OLE DB source. I select the connection ...
Started 2 weeks, 3 days ago (2008-12-22 08:15:00)
by Doug
I have the table definition between a production server and development server matching. The table allows NULLs with a default of space in some of the columns. Some of the production table's records contain a NULL value. Using the Transfer SQL Server Objects Task, the process is successful, but the records that have a NULL value ...
Started 3 weeks ago (2008-12-18 15:10:00)
by Burt
Hi Gurus, I want to import a "table" of data from Excel into an Oracle db using Excel like a db table and writing an "INSERT INTO" SQL statement. I don't want to use the visual tools because some of the joins are complicated. How would I do this? SSIS doesn't seem to like an INSERT statement in the SQL Command Text window of the...
Started 3 weeks, 3 days ago (2008-12-15 17:54:00)
by Raymond Chiu
If I have made 70+ SSIS package with SSIS import/Export wizard, there exist data source and destination. At this time, I created under the testing database environment with testing computer. When production time in another database, How can I change the data source and destination as specified in the SSIS import/Export Wizard of 70+ ...
Started 3 weeks, 1 day ago (2008-12-17 13:15:00)
by sql_noob
we have a server that used to be SQL 2000 and is now SQL 2005. when it was SQL 2000 we set up a DTS package on it to import some data from a Sybase server. The process was drop the destination tables, create them and then copy the data. over the last few years the Sybase side has grown to 5 servers and we upgraded the SQL 2000 ...
Started 3 weeks, 1 day ago (2008-12-17 12:33:00)
by imani_technology_spam@yahoo.com
Has anyone attempted to use SSIS to extract data from Netezza and load them into text files? Is it even possible?
|
|
Hot threads for last week on microsoft.public.sqlserver.integrationsvcs::
Started 2 days, 19 hours ago (2009-01-06 07:44:00)
by Mike
How do you delete SSIS projects from Visual Studio / BIDS, including getting rid of them in the 'Recent Projects' area of the Start Page? Thanks, Mike
Started 3 days, 8 hours ago (2009-01-05 18:54:00)
by tg112001 via SQLMonster.com
SQL Server 2005 SP3 & Excel 2003 -------------------------------------------------- ---------------------------- -------- I have a package that exports data to an excel template. What I'd like to do is format the excel file after the sheet is dropped and reloaded. Can someone point me to sample VBS where I can connect to the ...
Started 1 day, 8 hours ago (2009-01-07 19:09:00)
by tg112001 via SQLMonster.com
Hi, I'm fairly new to SSIS and need some help on passing date variables. I'm pulling data from an Oracle db to our SS environment and have created 2 variables named: START (value = 21-DEC-2008) END (value = 28-DEC-2008) How do I pass these variables to this statement: SELECT Column1, Column2,...
|
|
Size: 1,195 bytes
