SQL Server Integration Services Interview Questions 

I am a SQL Developer and dont really know .NET that well.

I am creating a custom data flow component for SSIS which performs encryption and decryption on string columns. I have been given the encryption algorithm and didnt write it myself but have adapted it to hook into the data flow pipeline of SSIS.

It works except when the decrypt method runs into a string that isnt actually encrypted. The encrypted value is stored in hex and part of the code converts a hex pair into an integer. This part of the code can generate a typemismatch exception and brings down the whole package.

How can i trap a Type Mismatch error caused by this line of code:

strChar = Chr(CInt("&H" & strChar))

Ideally, I need to direct the failed records down the error pipeline flow but just trapping the error at this stage would be a start.

Thanks.

I've been a programmer for over 10 years now, doing all kinds of different things. Mostly VB, VBA, Access, SQL Server, SSIS/SSRS,Oracle... I'm not even 40 yet and it seems like it's always an uphill battle. If I do something else (say SQL) and then a couple of months later I come back to Access, it's like there's a lot of stuff I just can't seem to remember how to do. I just pretty much can't code off the top of my head at all... i constantly have to look everything up. I see other people who seem to be able to remember this stuff. I feel like I'm stupid.
I saw a doctor a while ago and he didn't think much of it... I kinda felt like he thought I was maybe borderline hypochondriac or something). Anyway, why is my brain always feeling overloaded... i can't remember sh!t.

this is kareem uddin new to this group and recently starting with as the sql developer.

In order to successfully execute SSIS packages outside of the BI Studio, the full version of Integration Services needs to be installed (not just tools). Which edition includes the full version?

I was trying to download a trial version of SQL 2005 where in SSIS can be performed. I downloaded a server managment studio express but found out that what I really need is not the Express, can anyone help me to find the link where can I download the trial version. Or can I download it from the internet? Thanks in advance.

I work as a data administrator/account manger and at an advanced level in access/excel. I have also started to to utilise sql 2000 and I am looking to specialise in this area.

I am particularly interested in nailing sql, and specifically making use of sql2005's SSIS package.

Therefore, I was wonder what peoples opinions were on MC courses/exams and which course would be the most suited to my requirements?

Thanks all.

Is there a step by step method? See, I'm a novice to SQL Server, we were trying to test the SSIS functionality available in SQL 2005, particularly in server management studio, i need help..anyone who could help me..thanks!

I have never really worked with SSIS but I have a situation and I am wondering if a SSIS project could take care of it for me. SAP is going to be dumping flat text files (not IDOCS) into a folder, I want to grab those files, parse out the data that I need, and store the data into the SQL Server 2005 DB. Is it possible to write a program that can do this using SSIS. A SSIS project that will grab files every X seconds, parse that data, then run SP's to insert the SAP data into the correct SQL tables in my database? I know I can write a C# application to do this but I was wondering if this can be accomplished through SSIS?

Sure, you could make a parameter name '0', but why would you want to do so? Wouldn't make much sense to me.

I need to read in a file that is created say every 30s and store the info into my database. Can SSIS file manager grab files of a certain type (*.txt) or does it need a full file name? Also when the package runs as a job will it only grab one file and then the job is completed or will it keep running as long as there are files in the folder?

I have just started my career with SQL and am in a continuous struggle to grasp the basics. any link or help on the topic is highly appreciated. Regards.

We're making the transition from 2000 to 2005 and we're trying to figure out how best to develop SSIS packages. We're used to DTS where you can design and execute from the old enterprise manager. But with 2005, we can't figure out how to design or execute from Management Studio, other than sceduling a SQL Server Agent job. Creating and executing from Visual Studio is a pain and doesn't really suit our needs. We need to be able to do it from Management Sudio.

In SSIS , i created sql procedure the will return huge amount of records and using SSIS Control i have stored as flat file, how to do?