Books For Scripting (.NET) In SSIS...
Apr 10, 2008Could someone recommend good books for scripting with .NET in SSIS? Anyother useful websites that have this kind of stuff? Appreciate any help.
View 5 Replies
ADVERTISEMENT
SSIS Books
Apr 2, 2007Hi,
I am new to SSIS and wondered if there are any books around to learn in depth regarding SSIS and exampls for transformation to try and help me understand it better.
If anybody knows any guide, please let me know
Aash.
Books For SSIS
Sep 12, 2006Hi,
Please give the Microsoft suggested book material list for learning SSIS
Thanks & Regards
S.Nagarajan
Books On SSIS Programming
Jun 14, 2006Hi,
Can you please suggest the books which cover SSIS programming in C#?
Regards,
Gopi
Reusability && SSIS - Issues They Do Not Write In Books About
Feb 14, 2007I have a simple requirement:
Each package needs to have Error Handling - which needs to Execute a SQL statement. It's the same Stored Proc - where each package passes in its ID.
Ok - I get that part about creating a custom task and so on for reusabilty.
But - lets say that after deploying this task in 20 packages - I need to change the name of the Stored Proc.
What is going to happen in that case?
Correct me if I'm wrong - but after deploying the new version of the custom task - do I need to go to each package and update the reference to new version?
About Scripting In SSIS.
May 17, 2007Hi all,
I am new to SSIS...and wanted to know where can i get a lot of info on how to deal with ActiveX Scripttasks & Script tasks in SSIS...the place i am working has a lot of VB Scripting done in DTS Packages...having a hard time in understanding the Scripts, as i am more like back-end guy and wanted to learn a lot in SSIS, once i understand the scripts it will help me a great deal as to how to approach the tasks...Is there any website which teaches how to avoid Scripting in SSIS as i read somewhere that Scripting should be avoided as much as possible by making using of so many tasks in the SSIS tool.
I will look forward for someone to help me out and show me a way.
thanks
ravi
Nothing much that i can do..!!
SSIS Scripting
Feb 6, 2008Has anyone used this shiit ??
its an absolutely useless pile of crap ??
I can't do simple things that were done easily with Active X ..
USELESS...
Scripting In SSIS
Dec 6, 2007Hi, Does anyone have any suggestions on a book about scripting in SSIS. I'm currently using the WROX SQL Server 2005 Integratin Services book. This is an excellent book, but I need something that has more on scripting in SSIS.
My background is dba work, not programming. Thanks.
Advice On Scripting In SSIS..
May 17, 2007Hi all,
I am new to SSIS...and wanted to know where can i get a lot of info(from web/book) on how to deal with ActiveX Scripttasks & Script tasks in SSIS...the place i am working has a lot of VB Scripting done in DTS Packages...having a hard time in understanding the Scripts, as i am more like back-end guy and wanted to learn a lot in SSIS, once i understand the scripts it will help me a great deal as to how to approach the tasks...Is there any website which teaches how to avoid Scripting in SSIS as i read somewhere that Scripting should be avoided as much as possible by making using of so many tasks in the SSIS tool.
I will look forward for someone to help me out and show me a way.
thanks
ravi
Nothing much that i can do..!!
Best SSIS Scripting Tome?
Nov 29, 2006Is The Rational Guide to Scripting SQL Server 2005 Integration Services Beta Preview by Donald Farmer the best way to learn how to use scripting in SSIS as of late 2006? I'm not a .NET developer, although I come from a Java and C++ background.
I already own Professional SQL Server 2005 Integration Server, but that one doesn't cover scripting so much.
Thanks in advance.
How To Run An Exe In The SSIS Scripting Task
Jan 11, 2006Hi,
Can anyone help me how to run an exe file in the scripting task.
I was trying the below code but it's giving an error.
Set wshShell = WScript.CreateObject ("WSCript.shell")
wshshell.run "c:TestABC.exe", 6, True
set wshshell = nothing
Thanks,
rkn
4 Errors When Using SSIS Scripting Component
Nov 7, 2006
Hi guys, I got these errors when writing a scripting component. Anyone encounteer these errors before?
Warning 1 The dependency 'EnvDTE' could not be found.
Warning 2 The dependency 'Microsoft.SqlServer.VSAHosting' could not be found.
Warning 3 The dependency 'Microsoft.SqlServer.DtsMsg' could not be found.
Warning 4 The dependency 'Microsoft.SqlServer.VSAHostingDT' could not be found.
-Daren
SSIS Data Transformation Using Look Up Or Scripting???
Mar 6, 2008Hi all,
I've got to change values in my source database as follows:
Source: Target:
X 1
Y 1
Z 2
Can I create a lookup table and us a look up task in SSIS to do this or do I need to script it?
Thanks
F
Deleting Files Using SSIS Scripting Object
Jun 5, 2006I am utlizing a scripting object in my ssis to combine two text files into one final file, and then I want to delete the original files. To do this I am utilizing the FileSystemInfo namespace and associating the file names, then utilizing the DELETE functionality.
The creation of the final file works perfectly...unfortunately, my base files do not delete, and I do not get a failure message or indictator.
Here is my code:
' Microsoft SQL Server Integration Services Script Task
' Write scripts using Microsoft Visual Basic
' The ScriptMain class is the entry point of the Script Task.
Imports System
Imports System.Data
Imports System.Math
Imports System.IO
Imports System.IO.File
Imports System.IO.FileSystemInfo
Imports Microsoft.SqlServer.Dts.Runtime
Public Class ScriptMain
' The execution engine calls this method when the task executes.
' To access the object model, use the Dts object. Connections, variables, events,
' and logging features are available as static members of the Dts class.
' Before returning from this method, set the value of Dts.TaskResult to indicate success or failure.
'
' To open Code and Text Editor Help, press F1.
' To open Object Browser, press Ctrl+Alt+J.
Public Sub Main()
Dim strCurrentMonth As String
Dim strCurrentYear As String
Dim strWriteFileName As String
Dim strReadHeaderFileName As String
Dim strReadBodyFileName As String
'Utilizing a case statement, determine the monthname & year and set the appropriate variables
Select Case Month(Now())
Case 1
strCurrentMonth = "January"
Case 2
strCurrentMonth = "February"
Case 3
strCurrentMonth = "March"
Case 4
strCurrentMonth = "April"
Case 5
strCurrentMonth = "May"
Case 6
strCurrentMonth = "June"
Case 7
strCurrentMonth = "July"
Case 8
strCurrentMonth = "August"
Case 9
strCurrentMonth = "September"
Case 10
strCurrentMonth = "October"
Case 11
strCurrentMonth = "November"
Case 12
strCurrentMonth = "December"
End Select
strCurrentYear = Year(Now()).ToString
'Set variables with file names (reader files and write file) for ease in readability and to
'set final (write file) with appropriate nameing convention utilized by Matria HealthCare.
strWriteFileName = "\CUPSRV05SHAREDISPublicData ExportMatriaFiles TO Matriacup_ref_cup_" & strCurrentMonth & strCurrentYear & "_ftp_ReferralFormat.txt"
strReadHeaderFileName = "\CUPSRV05SHAREDISPublicData ExportMatriaFiles TO MatriaMatria_Referral_Control.txt"
strReadBodyFileName = "\CUPSRV05SHAREDISPublicData ExportMatriaFiles TO MatriaMatria_Referral.txt"
'create stream reader/writer objects
Dim sr As New StreamReader(strReadHeaderFileName)
Dim sr2 As New StreamReader(strReadBodyFileName)
Dim sw As New StreamWriter(strWriteFileName)
'feed the header record into the final file
Do Until sr.Peek = -1
'write the header record
sw.WriteLine(sr.ReadLine)
Loop
'close the read stream for the header record file
sr.Close()
'Feed the body records into the final file
Do Until sr2.Peek = -1
'write all base records
sw.WriteLine(sr2.ReadLine)
Loop
'close the read stream for the body records
sr2.Close()
'close the write stream for the final distribution file
sw.Close()
'dispose of all stream objects
sr.Dispose()
sr2.Dispose()
sw.Dispose()
Dim EligBaseFile As New FileInfo("strReadBodyFileName")
Dim EligHeaderFile As New FileInfo("strReadHeaderFileName")
EligBaseFile.Delete() <--These do not delete or through an error
EligHeaderFile.Delete()
'final statement for SSIS package to determine script result
Dts.TaskResult = Dts.Results.Success
End Sub
End Class
I would appreciate any light you can shed on this. Thanks!
Add Reference To Excel In Scripting Tool In SSIS 2005
Sep 24, 2007How can I add a reference to the Microsoft excel 2003 in the script tool in SSIS 2005? I need to automate Excel for formatting.
Thank you.
Dan
Data Scripting Tool ( NOT DATABASE Scripting)
Mar 16, 2004Hi to all
Is there any option in sql server DTS or any other third party tool that can script data. By scripting data i mean that....
if a table "Employee" contains 50 rows, i want the tool to write 50 insert queries for me so that i can run in it anywhere.
Problem is i have to insert data in a remote server where i cannot use DTS. I just have a text area to write my query and press the run button..
Hope u understand my problem. In case of any explanation please reply. Waiting for your response. Thanx in advance.
by to all
Books
Sep 2, 2004any all-rounder good book on SQL Server
View 1 Replies View RelatedSQL Books
Aug 11, 1999I would like to know what book is considered the best when it comes to optimizing SQL Server configurations and troubleshooting SQL Server problems encountered in the error log.
View 1 Replies View RelatedSQL Books
Aug 11, 1999I would like to know what book is considered the best when it comes to optimizing SQL Server configurations and troubleshooting SQL Server problems encountered in the error log.
View 1 Replies View RelatedSql Books
Feb 5, 2002Hi,
I have to buy two books for the MIS dept for sql server 2000. Which one do you recommend? We are still on sql 7.0 and migrating to 2000 soon. All developers have good experience with sql server 7.0.
Want something that gives you recommendation about better practices for performance issues for writing SPs.
I read all the reviews on amazon and b&N . It's confusing to choose only two.
Any recommendations?
Books
Sep 20, 2001Can Anyone tell where I can found a tutorial about Transact-SQL ?
Thanks
Books SQL
Sep 2, 2004Hello, I wish SQL' Books.
Anyone help me..
Bye :rolleyes:
Sql Books
Jul 20, 2005hipls tell the site's where i can download free e-books,bye,s.premkumar
View 1 Replies View RelatedBooks
May 21, 2007Hi , i am new to certifications in general..
I would like to do the certification exam 70-431. However i want to study on my own instead of going to classes.
what if i get the microsoft e-learning books or microsoft press books? will this be enough in helpnig me with the course requirements?
what are the difference between the two e-learning and MS Press books?
Books On Line
Aug 7, 2001Hi,
I just started at a client's site and have found that the Books On Line has been removed (all other items are there in the program group instead of BOL). Is there a site at microsoft that mimicks BOL? (sybase has a 'sybooks on the web' which mimicks their 'Sybooks' product documentation.
Any help would be appreciated.
jim
Books On SQL Administrations
Feb 28, 2000Hi
I am looking for books on SQL 7.0 Administration. I would appreciate if any body could recomend.
regards
rajeev
Books - For SQL Server 7.0 DTS
Nov 3, 2000Can anyone recommend books on SQL Server 7.0 Data Transformation Services?
Looking to find info on importing data from a Sybase server to SQL server (need good examples). Thanks.
Any Good DTS Books
Sep 30, 2002Does anyone know of any good books on DTS? I am currently using SQL 7.
Thanks in advance
Any Good Books
Sep 14, 1998Hi there,
Any good books to Know the internals of MS-SQL server 6.5
Thanks
Vivek
Books Online
Aug 10, 2005How do you use BOL? I've heard time again that there is much info in BOL but when i look at it it seems too brief and not detailed. I find it hard to find what i'm looking for anyway. How do you use it?
Thanks!
CD, Books, Sites
May 24, 2006naresh writes "I would like to learn sql server 2000 and I do not have any programming experienc at all so how do i learn this programme. Do you have any suggestion or any basic books or materials you guys can refer to me
Thank you"
Nice Books?
Jun 14, 2006hi guys,
i m a newbee in SQL. i wanted to know which is the nice book to start with? anyone got ebooks of SQL2005?
Ref: Books/webcast On ETL
Oct 9, 2006we are trying to build warehouse in our company its very small database but still.
we have come to a point where we are able to pull reports from the database that we have created as OLTP which is truncated and reloading everyday .
Now we have to stop doing that and just update the database and check for the changes in the existing data.
Can anyone suggest ETL book/webcast/weblinks that could help me.
Thanks in advance
Srini